Re: Basic subtransaction facility

Поиск
Список
Период
Сортировка
От Manfred Koizar
Тема Re: Basic subtransaction facility
Дата
Msg-id opb290h7jjsh20ccmnf891dspiho8mpb7o@email.aon.at
обсуждение исходный текст
Ответ на Re: Basic subtransaction facility  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
Ответы Re: Basic subtransaction facility  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: Basic subtransaction facility  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
Список pgsql-patches
On Wed, 28 Apr 2004 12:02:44 -0400, Alvaro Herrera
<alvherre@dcc.uchile.cl> wrote:
>In fact, I think we should mark ERROR as aborting the whole transaction
>tree, and create a new level which would abort the innermost
>subtransaction.  We would then change whatever is appropiate to the new
>elevel.  Doing otherwise would leave us open to unexpected conditions
>causing only subtrans abort, which could lead to unreliable behavior.

Why?  Subtransaction commit propagates an error state to the parent
transaction.  And if a subtransaction is rolled back the parent can
continue cleanly no matter what was the reason for the subtrans abort.

Servus
 Manfred

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

Предыдущее
От: Sean Chittenden
Дата:
Сообщение: Re: SECURITY DEFINER not being propagated...
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Basic subtransaction facility