Re: commiting transaction from outside

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 <julius(at)nsoft(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/**mailpref/pgsql-admin<http://www.postgresql.org/mailpref/pgsql-admin>
>