Re: open transaction?

----- Original Message -----
From: "Terry Lee Tucker" <terry@chosen-ones.org>
To: <pgsql-general@postgresql.org>
Sent: Monday, December 29, 2008 5:57 AM
Subject: Re: [GENERAL] open transaction?


> On Monday 29 December 2008 06:48, blackwater dev wrote:
>> 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!
>
> If you don't commit, it is rolled back when you exit.
>
> --
> Terry Lee Tucker
> Turbo's IT Manager
> Turbo, division of OHL
> 2251 Jesse Jewell Pkwy
> Gainesville, GA 30501
> tel: (336) 372-6821 cell: (336) 404-6987
> terry@turbocorp.com
> www.turbocorp.com
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

But if all you did was SELECT, as you indicated, then no transaction
should have been started and it makes no difference.

Bayless