Re: current transaction is aborted, commands ignored until - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: current transaction is aborted, commands ignored until
Date
Msg-id 426432DA.8040400@commandprompt.com
Whole thread Raw
In response to current transaction is aborted, commands ignored until end of transaction...  (Thomas Kellerer <spam_eater@gmx.net>)
Responses Re: current transaction is aborted, commands ignored until
List pgsql-general
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 that I'm using, or is this a
> general Postgres problem?

I do not know if the JDBC interface supports savepoints.

>
> Is there a setting where I can control this behaviour?

If you can turn on autocommit with JDBC that will help.

SIncerely,

Joshua D. Drake


>
> I'm using 8.0.2 on Windows 2000 (and XP)
>
> Thanks for your help
> Thomas
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend


--
Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
Managed Services, Shared and Dedication Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/

pgsql-general by date:

Previous
From: Thomas Kellerer
Date:
Subject: current transaction is aborted, commands ignored until end of transaction...
Next
From: Scott Marlowe
Date:
Subject: Re: current transaction is aborted, commands ignored