Tagged Questions

0
votes
1answer
18 views

Forgotten PostgreSQL Windows password

This morning I’ve been trying to connect the Postgresql database on my Windows 7 professional desktop. The default value is ‘postgres’, but sure enough I forgot what password I used when I originally ...
0
votes
0answers
19 views

postgresql to mssql query conversion

can any one help me to convert the following query into mssql which is working on postgresql now query is to take the updated datetime of the report in the asc order of the date select count(*) ...
-3
votes
1answer
22 views

PostgreSQL Server Installation [closed]

I have been developing applications with SQL Server 2008 since last three years, and now one of my client wants to develop application with PostgreSQL 9.0 I don't know what management tools are used ...
0
votes
1answer
22 views

IS NOT DESTINCT FROM versus =

Can anyone please help me. I have the following postgresql query: SELECT count(*) FROM trackPointsA WHERE gid NOT IN ( SELECT a.gid FROM trackPointsA a, trackPointsB b WHERE a.the_geom = ...
0
votes
1answer
26 views

Postgres: Get the Complement of Distinct Entries

Currently I can get distinct entries from a table like this: SELECT DISTINCT ON (abc.entry) abc.* FROM table abc JOIN table1 def ON abc.entry = def.entry WHERE def.created >= 'some_date' AND ...
0
votes
1answer
50 views

Postgres Version

I have been asked to develop my new application with Postgres 10.0. Before this, I have been developing applications with MsSql and was quite easy even. I searched for the Version 10.0 but didn't find ...
0
votes
1answer
26 views

how to fix postgresql server automatic reboots [closed]

On some days PostgreSql server starts to reboot itself periodically. Log file is below. It contains found orphan temp table records and after that reboot is performed. Application is accessed by ...
1
vote
1answer
21 views

Function returns “query has no destination for result data”

I'm trying to create a function that will effectively function as an UPSERT and return either 0 for a successful UPDATE or the id of the new record for a successful INSERT. While the function will ...
0
votes
1answer
35 views

A table with infinite rows?

I have a table posts: Column | Type | Modifiers ...
1
vote
3answers
24 views

Find values not present in supplied list postgres

I am trying to find a query that will tell me the values that are not in my database. Eg: select seqID, segment from flu where seqID IN (1,2,3,4,5,6,7,8,9). Now if my database doesn't have ...
0
votes
1answer
25 views

How do I re-cast a Postgres column from Integer to Decimal?

I'd like to alter a column to convert from integer to decimal, setting all integer values to <value>.0. How do I do this?
0
votes
0answers
17 views

Multiple Relations on the same model

i'm having a problem retrieving related data of my model ProductsPproduct when i search with contain. My table is basically a mapping between ordered products and produced products for example ...
-2
votes
1answer
13 views

postgres syntax error in sql

select * from ( select max(h.updated_datetime) as max, min(h.updated_datetime) as min from report r, report_history h, procedure_runtime_information PRI, study S where ...
0
votes
1answer
26 views

Connection refused (PGError) (postgresql and rails)

I keep getting this error when i try to run my localhost using "$rails s": (Mac OSX 10.8.3) (ruby 2.0.0p195 (2013-05-14 revision 40734) [x86_64-darwin12.3.0]) (Rails 3.2.11) (psql (PostgreSQL) ...
-1
votes
1answer
23 views

how to find the latest revisions updated datetime and oldest revisions datetime in postgres with procedure_fk filter in postgresql [closed]

These are my tables i should find the latest revisions updated datetime and oldest revisions datetime in postgres with procedure_fk filter can any one help me thanks in advance CREATE TABLE ...

1 2 3 4 5 … 31
15 30 50 per page