Re: Nested transactions

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Nested transactions
Дата
Msg-id 20040509145931.GB2345@dcc.uchile.cl
обсуждение исходный текст
Ответ на Nested transactions  (Cassio Polpo de Campos <cassio@ime.usp.br>)
Список pgsql-hackers
On Sun, May 09, 2004 at 10:57:45AM -0300, Cassio Polpo de Campos wrote:

> I know nested transactions did not work on that versions, but this
> is exactly what I want to know. What happens if I put nested begins,
> commits, etc? Suppose we have the following:
> 
> begin work
> ...
> begin work
> ...
> commit
> ...
> commit

You'll get a warning in the second begin saying that you already are in
a transaction, and nothing will happen.  The first commit will commit,
and the second one will get another warning saying that you are not on a
transaction and there's nothing to commit.

-- 
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Siempre hay que alimentar a los dioses, aunque la tierra esté seca" (Orual)


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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: Relocatable installs
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Adding MERGE to the TODO list (resend with subject)