Skip site navigation (1) Skip section navigation (2)

Re: commiting transaction from outside

From: Julien Rouhaud <rjuju123(at)gmail(dot)com>
To: Julius Tuskenis <julius(at)nsoft(dot)lt>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: commiting transaction from outside
Date: 2011-10-03 17:48:41
Message-ID: CAOBaU_Ze+97TjE1ycFOAA3_TwQE0OaoPK2ne6dwM-iNLZRhykg@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
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>
>

In response to

pgsql-admin by date

Next:From: Kevin GrittnerDate: 2011-10-03 17:57:19
Subject: Re: commiting transaction from outside
Previous:From: Robert BurgholzerDate: 2011-10-03 17:34:20
Subject: Re: diagnosing a db crash - server exit code 2

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group