From: Julius Tuskenis <julius@nsoft.lt>
To: pgsql-admin@postgresql.org
Subject: commiting transaction from outside
Date: Mon, 03 Oct 2011 19:50:07 +0300
Message-ID: <4E89E7BF.9040009@nsoft.lt> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: julius@nsoft.lt
Subject: Re: commiting transaction from outside
In-Reply-To: <4E89E7BF.9040009@nsoft.lt>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox