Postgres Pro
Downloads
Home   >   mailing lists

Re: 25P02, current transaction is aborted, commands ignored - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: 25P02, current transaction is aborted, commands ignored
Date
Msg-id 442F722E.1090900@opencloud.com
Whole thread Raw
In response to 25P02, current transaction is aborted, commands ignored until end of transaction block  ("babu_moshay" <babu_moshay@indiatimes.com>)
List pgsql-jdbc
Tree view 
babu_moshay wrote:

> In my opinion, if there are reasons to throw 25P02 and abort transaction unilaterally,  then there are also good
reasonsnot to abort it and let programmer take the decision. A switching mechanism would have been ideal. 

Create a savepoint before the possibly-failing query. If the query fails
in the way you were expecting, roll back to the savepoint and continue.

-O

pgsql-jdbc by date:

Previous
From: "babu_moshay"
Date:
Subject: 25P02, current transaction is aborted, commands ignored until end of transaction block
Next
From: "Regász Imre"
Date:
Subject: Re: 25P02, current transaction is aborted, commands ignored until end of transaction block