From: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Sequence question |
Date: | 2004-10-20 17:00:22 |
Message-ID: | 20041020170022.GB5096@dcc.uchile.cl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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)
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Browne | 2004-10-20 17:20:11 | Re: files ending with .1 or .2 |
Previous Message | Josh Close | 2004-10-20 16:37:20 | Re: how much ram do i give postgres? |