Re: open transaction?

----- Original Message -----
From: "Terry Lee Tucker" <terry(at)chosen-ones(dot)org>
To: <pgsql-general(at)postgresql(dot)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(at)turbocorp(dot)com
> www.turbocorp.com
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)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