----- Original Message -----
From: "Terry Lee Tucker" <terry@xxxxxxxxxxxxxxx>
To: <pgsql-general@xxxxxxxxxxxxxx>
Sent: Monday, December 29, 2008 5:57 AM
Subject: Re: 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@xxxxxxxxxxxxx
www.turbocorp.com
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
