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)
On Mon, Oct 3, 2011 at 6:50 PM, Julius Tuskenis <jul...@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<http://www.postgresql.org/mailpref/pgsql-admin> >
