Re: Nested Transactions, Abort All - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Nested Transactions, Abort All
Date
Msg-id 20040709195902.GA27599@dcc.uchile.cl
Whole thread Raw
In response to Re: Nested Transactions, Abort All  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Nested Transactions, Abort All  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: Nested Transactions, Abort All  (Dennis Bjorklund <db@zigo.dhs.org>)
Re: Nested Transactions, Abort All  (Oliver Jowett <oliver@opencloud.com>)
List pgsql-hackers
On Fri, Jul 09, 2004 at 03:34:47PM -0400, Bruce Momjian wrote:
> Alvaro Herrera wrote:
> > On Fri, Jul 09, 2004 at 09:07:58PM +0200, Dennis Bjorklund wrote:
> > > On Fri, 9 Jul 2004, Alvaro Herrera wrote:
> > > 
> > > > Clearly savepoints do not allow for a snapshot to be released; nested
> > > > xacts do.
> > > 
> > > Why not?
> > 
> > What is it?
> 
> Simon posted it.  It is called RELEASE:

We can't actually release anything (commit the subtransactions), because
they may be savepoints established after that point, and they are
logically "inside" the previously established ones.  At RELEASE we can't
really release -- we just lose the name and thus the opportunity to
rollback to it.

-- 
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
Major Fambrough: You wish to see the frontier?
John Dunbar: Yes sir, before it's gone.



pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Nested Transactions, Abort All
Next
From: Bruce Momjian
Date:
Subject: Re: Nested Transactions, Abort All