[BUGS] duplicate key value violates unique constraint tableName_pk

2012-11-07 Thread Saravanan Nagarajan
Hi , I am using Copy From while dumping bulk data into PGSQL DB from file. While I am trying to insert the rows, if the primary key already exists, the complete transaction terminated. Postgres cannot handle the constraint violations , i found it into

[BUGS] PQsendQueryParams() causes prepared statement error

2012-11-07 Thread Denis Feklushkin
in 9.2.0: PQsendQueryParams() with multiple command statement (like select 123; select 456) unexpectedly causes error: cannot insert multiple commands into a prepared statement. But PQsendQuery() works fine. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to

Re: [BUGS] Bug reporting form :-(

2012-11-07 Thread Magnus Hagander
On Wed, Nov 7, 2012 at 3:30 AM, Denis Feklushkin denis.feklush...@gmail.com wrote: Hi! Bug reporting form: http://www.postgresql.org/support/submitbug/ is not works - it slows down and fails with CSRF verification failed (in google chrome, at least) Hi! Yeah, that definitely looks like

Re: [BUGS] PQsendQueryParams() causes prepared statement error

2012-11-07 Thread Tom Lane
Denis Feklushkin denis.feklush...@gmail.com writes: in 9.2.0: PQsendQueryParams() with multiple command statement (like select 123; select 456) unexpectedly causes error: cannot insert multiple commands into a prepared statement. This is not a bug, it's intentional (and documented) behavior.

Re: [BUGS] duplicate key value violates unique constraint tableName_pk

2012-11-07 Thread Pavan Deolasee
On Wed, Nov 7, 2012 at 4:51 PM, Saravanan Nagarajan n.saravana...@gmail.com wrote: Hi , I am using Copy From while dumping bulk data into PGSQL DB from file. While I am trying to insert the rows, if the primary key already exists, the complete transaction terminated. Postgres cannot

[BUGS] BUG #7640: Testing bug reporting form

2012-11-07 Thread magnus
The following bug has been logged on the website: Bug reference: 7640 Logged by: Magnus Hagander Email address: mag...@hagander.net PostgreSQL version: 9.2.1 Operating system: Web Description: This is just a test to make sure that the bug reporting form has been

[BUGS] BUG #7642: Unchecked “stats_temp_directory” causes server hang to requests

2012-11-07 Thread tixu
The following bug has been logged on the website: Bug reference: 7642 Logged by: Tianyin Xu Email address: t...@cs.ucsd.edu PostgreSQL version: 9.2.1 Operating system: Linux Description: Hi, Postgresql, I set the stats_temp_directory='' in my postgresql.conf file,

Re: [BUGS] BUG #7642: Unchecked “stats_temp_directory” causes server hang to requests

2012-11-07 Thread Tom Lane
t...@cs.ucsd.edu writes: I set the stats_temp_directory='' in my postgresql.conf file, with the expectation that the directory would be under the data directory. Why would you think that's a good idea? It's already going to be under the data directory. The only reason to change this setting

[BUGS] Re: [BUGS] BUG #7642: Unchecked “stats_temp_directory” causes server hang to requests

2012-11-07 Thread Tianyin Xu
Thanks for the reply, Tom. On Wed, Nov 7, 2012 at 10:53 AM, Tom Lane t...@sss.pgh.pa.us wrote: t...@cs.ucsd.edu writes: I set the stats_temp_directory='' in my postgresql.conf file, with the expectation that the directory would be under the data directory. Why would you think that's a

Re: [BUGS] duplicate key value violates unique constraint tableName_pk

2012-11-07 Thread Craig Ringer
On 11/07/2012 07:21 PM, Saravanan Nagarajan wrote: Hi , I am using Copy From while dumping bulk data into PGSQL DB from file. While I am trying to insert the rows, if the primary key already exists, the complete transaction terminated. Postgres cannot handle the constraint violations , i

Re: [BUGS] PQsendQueryParams() causes prepared statement error

2012-11-07 Thread Denis Feklushkin
В Срд, 07/11/2012 в 11:48 -0500, Tom Lane пишет: Denis Feklushkin denis.feklush...@gmail.com writes: in 9.2.0: PQsendQueryParams() with multiple command statement (like select 123; select 456) unexpectedly causes error: cannot insert multiple commands into a prepared statement. This

[BUGS] BUG #7641: ERROR: must specify relation and object name when function contains DROP TRIGGER

2012-11-07 Thread sergey
The following bug has been logged on the website: Bug reference: 7641 Logged by: Sergey Email address: ser...@booksys.com PostgreSQL version: 9.2.1 Operating system: Windows XP / Ubuntu 10.04 (Lucid) Description: Postgres 9.2.1 Reproduced the problem on Windows XP