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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-general by date

  From Date Subject
Next Message Raymond O'Donnell 2008-12-29 11:53:54 Re: open transaction?
Previous Message Grzegorz Jaśkiewicz 2008-12-29 10:43:23 Re: having two database clusters?