Re: Cancelling idle in transaction state
| От | Simon Riggs |
|---|---|
| Тема | Re: Cancelling idle in transaction state |
| Дата | |
| Msg-id | 1262174686.19367.5083.camel@ebony обсуждение исходный текст |
| Ответ на | Re: Cancelling idle in transaction state (Joachim Wieland <joe@mcknight.de>) |
| Список | pgsql-hackers |
On Wed, 2009-12-30 at 11:43 +0100, Joachim Wieland wrote: > 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. True > Subsequent commands will be executed just fine > instead of being refused with the error message that the transaction > is already aborted... True, but it is a subsequent transaction, not the same one. (I've checked). -- Simon Riggs www.2ndQuadrant.com
В списке pgsql-hackers по дате отправления: