Tagged Questions

for PostgreSQL questions specific to version 9.1.

learn more… | top users | synonyms

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
18 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
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 ...
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
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 ...
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 ...

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