Re: Nested Transactions, Abort All

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Nested Transactions, Abort All
Дата
Msg-id 20040710195634.GA5238@dcc.uchile.cl
обсуждение исходный текст
Ответ на Re: Nested Transactions, Abort All  (Dennis Bjorklund <db@zigo.dhs.org>)
Список pgsql-hackers
On Sat, Jul 10, 2004 at 09:46:00PM +0200, Dennis Bjorklund wrote:

> One can have many different semantics, here are 3 versions:
> 
>  1) You release savepoints in any order
>  2) You release savepoints in reverse order
>  3) You release any savepoints and later ones then the
>     one you released are automatically released.
> 
> I don't see any of these as absurd. The ansi spec uses number 3.

Ah-ha, now I see what I failed to see previously: all later savepoints
are also released!  This makes a lot more sense.  So "release" is
exactly like commit nested, allowing several levels to be "committed".

-- 
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"La fuerza no está en los medios físicos
sino que reside en una voluntad indomable" (Gandhi)



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

Предыдущее
От: Dennis Bjorklund
Дата:
Сообщение: Re: Nested Transactions, Abort All
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [BUGS] BUG #1118: Misleading Commit message