Re: Sequence question

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Sequence question
Дата
Msg-id 20041020170022.GB5096@dcc.uchile.cl
обсуждение исходный текст
Ответ на Re: Sequence question  (Andrew Sullivan <ajs@crankycanuck.ca>)
Список pgsql-general
On Wed, Oct 20, 2004 at 11:57:42AM -0400, Andrew Sullivan wrote:

> Now, how do you handle the cases where either the transaction fails
> so you can't set it to 3?  Simple: your client captures errors and
> then sets the value back to 1 later.

Has anyone read "the Sagas paper" by Garcia-Molina?  They present a way
to handle "extended transaction models", trying to cope sort-of
automatically with this kind of situations.  More generally, AFAIU the
idea is to have multi-transaction recoverability and rollback-ability.
It seems interesting.

http://portal.acm.org/citation.cfm?doid=38713.38742

I have only skimmed through it, but it sounds somewhat interesting.
I'd love to know what do people think of this.

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Los dioses no protegen a los insensatos.  Éstos reciben protección de
otros insensatos mejor dotados" (Luis Wu, Mundo Anillo)


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

Предыдущее
От: Josh Close
Дата:
Сообщение: Re: how much ram do i give postgres?
Следующее
От: Hagen Hoepfner
Дата:
Сообщение: Re: Views + UNION ALL = Slow ?