Re: commiting transaction from outside
| От | Julien Rouhaud |
|---|---|
| Тема | Re: commiting transaction from outside |
| Дата | |
| Msg-id | CAOBaU_Ze+97TjE1ycFOAA3_TwQE0OaoPK2ne6dwM-iNLZRhykg@mail.gmail.com обсуждение исходный текст |
| Ответ на | commiting transaction from outside (Julius Tuskenis <julius@nsoft.lt>) |
| Список | pgsql-admin |
Hi
I'm sorry but there's no way to commit a transaction from outside, except if your application uses the two-phase commit (PREPARE TRANSACTION id_transaction)
I'm sorry but there's no way to commit a transaction from outside, except if your application uses the two-phase commit (PREPARE TRANSACTION id_transaction)
On Mon, Oct 3, 2011 at 6:50 PM, Julius Tuskenis <julius@nsoft.lt> wrote:
Hello,
my question my sound strange, but because of a bug in an application I see the transaction was started and not commited (connection state is IDLE in transaction). Is there a way to commit this transaction? I don't want to loose data. I think if I close the application the transaction would get rollbacked.
I've tried google'ing but without results - this might mean, that there is no way, but I thought asking is an option..
Thank you in advance for any advice.
--
Julius Tuskenis
Programavimo skyriaus vadovas
UAB nSoft
mob. +37068233050
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
В списке pgsql-admin по дате отправления: