Re: 25P02, current transaction is aborted, commands ignored

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: babu_moshay <babu_moshay(at)indiatimes(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: 25P02, current transaction is aborted, commands ignored
Date: 2006-04-02 06:41:50
Message-ID: 442F722E.1090900@opencloud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

babu_moshay wrote:

> In my opinion, if there are reasons to throw 25P02 and abort transaction unilaterally, then there are also good reasons not 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

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Regász Imre 2006-04-02 08:58:55 Re: 25P02, current transaction is aborted, commands ignored until end of transaction block
Previous Message babu_moshay 2006-04-02 05:01:24 25P02, current transaction is aborted, commands ignored until end of transaction block