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

Re: open transaction?

From: Raymond O'Donnell <rod(at)iol(dot)ie>
To: blackwater dev <blackwaterdev(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: open transaction?
Date: 2008-12-29 11:53:54
Message-ID: 4958BA52.8060003@iol.ie (view raw or flat)
Thread:
Lists: pgsql-general
On 29/12/2008 11:48, blackwater dev wrote:

> Without thinking I closed by connection before committing or rolling
> back my transaction.  Did postgres handle this for me?  How do I see if
> the transaction is still open?

I'm reasonably sure that the transaction will get rolled back if the
connection dies.

Ray.


------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod(at)iol(dot)ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

In response to

Responses

pgsql-general by date

Next:From: Terry Lee TuckerDate: 2008-12-29 11:57:48
Subject: Re: open transaction?
Previous:From: blackwater devDate: 2008-12-29 11:48:34
Subject: open transaction?

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