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@xxxxxxxx> 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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
