Re: Nested Transactions, Abort All

Поиск
Список
Период
Сортировка
От Jeroen T. Vermeulen
Тема Re: Nested Transactions, Abort All
Дата
Msg-id 20040702215101.GH50626@xs4all.nl
обсуждение исходный текст
Ответ на Re: Nested Transactions, Abort All  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
Ответы Re: Nested Transactions, Abort All
Список pgsql-hackers
On Fri, Jul 02, 2004 at 05:30:49PM -0400, Alvaro Herrera wrote:
> You can't have subtransactions inside an implicit transaction block, so

Haven't been following this thread closely, but just my 2 cents...

If you collate queries using the semicolon, AFAIK the whole thing is
executed as a single implicit transaction (if not in an explicit one
already, of course).  So is there anyone stopping a user from executing

BEGIN ; UPDATE ... ; COMMIT

?


Jeroen



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Nested Transactions, Abort All
Следующее
От: "Greg Sabino Mullane"
Дата:
Сообщение: Re: [Re] Re: PREPARE and transactions