[BUGS] Bug reporting form :-(

2012-11-07 Thread Denis Feklushkin
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) -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresq

[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 http://wiki.postgresql.org/wiki/COPY#Caveat

[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

Re: [BUGS] Bug reporting form :-(

2012-11-07 Thread Magnus Hagander
On Wed, Nov 7, 2012 at 3:30 AM, Denis Feklushkin 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 fallout from a pat

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

2012-11-07 Thread Tom Lane
Denis Feklushkin 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 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

[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 unbro

Re: [BUGS] Bug reporting form :-(

2012-11-07 Thread Magnus Hagander
On Wed, Nov 7, 2012 at 3:53 PM, Magnus Hagander wrote: > On Wed, Nov 7, 2012 at 3:30 AM, Denis Feklushkin > 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,

[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, wi

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

2012-11-07 Thread Tianyin Xu
OSH, why the format becomes so ugly?!! Here's the original mail. Hi, Postgresql, I set the stats_temp_directory='' in my postgresql.conf file, with the expectation that the directory would be under the data directory. However, the server convert the file to “/pgstat.tm

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 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 good idea? It

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 violatio

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

2012-11-07 Thread Denis Feklushkin
В Срд, 07/11/2012 в 11:48 -0500, Tom Lane пишет: > Denis Feklushkin 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 bu

[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 and