Re: open transaction?
От | Bayless Kirtley |
---|---|
Тема | Re: open transaction? |
Дата | |
Msg-id | F003EA43055043308E3075EF10662CCF@dell2400 обсуждение исходный текст |
Ответ на | open transaction? ("blackwater dev" <blackwaterdev@gmail.com>) |
Ответы |
How can the error log be searched?
|
Список | pgsql-general |
----- 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
В списке pgsql-general по дате отправления: