Tagged Questions

for PostgreSQL questions specific to version 9.1.

learn more… | top users | synonyms

-2
votes
0answers
14 views

PostgreSQL Server Installation

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
16 views

How to Write Integration test to check whether throwing exception in JAVA using TestNG?

I have a DAO which return some values and how to check a method throws an specific exception?
0
votes
1answer
17 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
21 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
49 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
21 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 ...
0
votes
1answer
11 views

Unable to copy postgresql table in another database

I try to copy postgresql table in another database as I write in pgAdmin 3 this query $pg_dump -t pl_biz_enhanced business_catalog | psql business_catalog_enhanced here pl_biz_enhanced is the ...
1
vote
1answer
20 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
34 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 ...
0
votes
0answers
24 views

Can't cast System.Collections.Generic.List into any valid DbType - Npgsql

I can update using Npgsql without a problem if i have int,double,string, but with List it is not working. For example: com.Parameters.Add(new Npgsql.NpgsqlParameter("@number", number)); works ...
-2
votes
1answer
11 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
24 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 2 3 4 5 … 47
15 30 50 per page