From: Alvaro Herrera <alvherre@dcc.uchile.cl>
To: pgsql-general@postgresql.org
Subject: Re: Sequence question
Date: Wed, 20 Oct 2004 14:00:22 -0300
Message-ID: <20041020170022.GB5096@dcc.uchile.cl> (raw)
In-Reply-To: <20041020155742.GB8721@phlogiston.dyndns.org>
References: <41753069.3000406@bonbon.net>
<20041020155742.GB8721@phlogiston.dyndns.org>
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)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-general@postgresql.org
Cc: alvherre@dcc.uchile.cl
Subject: Re: Sequence question
In-Reply-To: <20041020170022.GB5096@dcc.uchile.cl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox