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

open transaction?

From: "blackwater dev" <blackwaterdev(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: open transaction?
Date: 2008-12-29 11:48:34
Message-ID: 34a9824e0812290348j3929a5ebn5541f8fe0dcd2db6@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-general
I just logged into postgres from the command line and did:

begin:

select blah;
select blah;

\q

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?

Thanks!

Responses

pgsql-general by date

Next:From: Raymond O'DonnellDate: 2008-12-29 11:53:54
Subject: Re: open transaction?
Previous:From: Grzegorz JaƛkiewiczDate: 2008-12-29 10:43:23
Subject: Re: having two database clusters?

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