Re: Cancelling idle in transaction state - Mailing list pgsql-hackers

From Joachim Wieland
Subject Re: Cancelling idle in transaction state
Date
Msg-id dc7b844e0912300243m346b2883n2b6ecd38dcc0eba4@mail.gmail.com
Whole thread Raw
In response to Re: Cancelling idle in transaction state  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: Cancelling idle in transaction state  (Simon Riggs <simon@2ndQuadrant.com>)
List 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


pgsql-hackers by date:

Previous
From: Kris Jurka
Date:
Subject: Re: Cancelling idle in transaction state
Next
From: "Tarun Sharma"
Date:
Subject: Re: Can we hide data from the superadmin