Horton
Menu

Re: Cancelling idle in transaction state

Joachim Wieland <joe@mcknight.de>

View thread
From: Joachim Wieland <joe@mcknight.de>
To: Simon Riggs <simon@2ndquadrant.com>
Cc: Kris Jurka <books@ejurka.com>, Tom Lane <tgl@sss.pgh.pa.us>, Hannu Krosing <hannu@2ndquadrant.com>, James Pye <lists@jwp.name>, pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2009-12-30T10:43:08Z
Lists: pgsql-hackers 
On Wed, Dec 30, 2009 at 12:28 AM, Simon Riggs <simon@2ndquadrant.com> wrote:
>> I had to write an additional function AbortAnyTransaction() which
>> aborts all transactions and subtransactions and leaves the transaction
>> in the aborted state, is there an existing function to do this?
>
> AbortOutOfAnyTransaction()

But this would clean up completely and not leave the transaction in
the aborted state. Subsequent commands will be executed just fine
instead of being refused with the error message that the transaction
is already aborted... Right?


Joachim