Re: [GENERAL] current transaction is aborted, commands ignored until end of transaction block

2007-05-30 Thread Richard Huxton
Vang wrote: Hello, I'm using PostgreSQL 8.0 and Java in NetBeans IDE. In java I have a method that does a "insert into" and it throws a "duplicate key violates unique constraint." I call that method once and then call another method which does a "select." However, when the select method gets

[GENERAL] current transaction is aborted, commands ignored until end of transaction block

2007-05-30 Thread Vang
Hello, I'm using PostgreSQL 8.0 and Java in NetBeans IDE. In java I have a method that does a "insert into" and it throws a "duplicate key violates unique constraint." I call that method once and then call another method which does a "select." However, when the select method gets called post

Re: [GENERAL] "current transaction is aborted, commands ignored until

2005-05-06 Thread Richard Huxton
Ying Lu wrote: Greetings, Through java - JDBC, trying to do "select * from Table" using "lock table IN SHARE MODE"; Always got this error: "current transaction is aborted, commands ignored until end of transaction block" One of your commands has an error, and the transaction has been aborted be

[GENERAL] "current transaction is aborted, commands ignored until end of transaction block" Error

2005-05-05 Thread Ying Lu
Greetings, Through java - JDBC, trying to do "select * from Table" using "lock table IN SHARE MODE"; Always got this error: "current transaction is aborted, commands ignored until end of transaction block" Some clues about it? Thanks a lot! Emi ---(end of broadcast)-

Re: [GENERAL] current transaction is aborted, commands ignored until

2005-04-18 Thread Thomas Kellerer
On 19.04.2005 02:33 Kris Jurka wrote: Is this a problem with the JDBC interface that I'm using, or is this a general Postgres problem? >>> > > This is an open todo item for the JDBC driver. It could be done by > automatically wrapping all statements in savepoints behind the scenes. >

Re: [GENERAL] current transaction is aborted, commands ignored until

2005-04-18 Thread Kris Jurka
On Tue, 19 Apr 2005, Thomas Kellerer wrote: > Joshua D. Drake wrote on 19.04.2005 00:21: > >> I'm having a bit of trouble with the error message from the subject. > >> Is there a way to simply go on with my commands if I hit this error? > > > > Only if you are using savepoints (nested transact

Re: [GENERAL] current transaction is aborted, commands ignored until

2005-04-18 Thread Thomas Kellerer
Joshua D. Drake wrote on 19.04.2005 00:21: I'm having a bit of trouble with the error message from the subject. Is there a way to simply go on with my commands if I hit this error? Only if you are using savepoints (nested transactions) otherwise you must rollback. Is this a problem with the JDBC

Re: [GENERAL] current transaction is aborted, commands ignored until

2005-04-18 Thread Joshua D. Drake
Thomas Kellerer wrote: Hello, I'm having a bit of trouble with the error message from the subject. Is there a way to simply go on with my commands if I hit this error? Only if you are using savepoints (nested transactions) otherwise you must rollback. Is this a problem with the JDBC interface th

[GENERAL] current transaction is aborted, commands ignored until end of transaction...

2005-04-18 Thread Thomas Kellerer
Hello, I'm having a bit of trouble with the error message from the subject. Is there a way to simply go on with my commands if I hit this error? One example would be when I drop a table (and it doesn't exist) I still want to run the following CREATE TABLE. But due to the error even the followin

Re: [GENERAL] current transaction is aborted, commands ignored until

2004-10-05 Thread [EMAIL PROTECTED]
Hi Michael: Michael Fuhr wrote: After upgrading 7.4.2 to 7.4.5 quite smoothly in a Red Hat 8.0 box, we are having intermitent issues with certain online PHP transactions, returning this error: "Warning: pg_exec() query failed: ERROR: current transaction is aborted, commands ignored until end of

Re: [GENERAL] current transaction is aborted, commands ignored until end of transaction block

2004-10-05 Thread Michael Fuhr
On Tue, Oct 05, 2004 at 07:54:23AM +0200, ruben wrote: > After upgrading 7.4.2 to 7.4.5 quite smoothly in a Red Hat 8.0 box, we > are having intermitent issues with certain online PHP transactions, > returning this error: > > "Warning: pg_exec() query failed: ERROR: current transaction is abort

[GENERAL] current transaction is aborted, commands ignored until end of transaction block

2004-10-04 Thread ruben
Hi: After upgrading 7.4.2 to 7.4.5 quite smoothly in a Red Hat 8.0 box, we are having intermitent issues with certain online PHP transactions, returning this error: "Warning: pg_exec() query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block" Half th