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