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

From Alvaro Herrera
Subject Re: Nested Transactions, Abort All
Date
Msg-id 20040709204351.GA27948@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
List pgsql-hackers
On Fri, Jul 09, 2004 at 04:07:19PM -0400, Bruce Momjian wrote:
> Alvaro Herrera wrote:

> > 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.
> 
> Oh, good point.  Yes, those savepoints in between are still active.  But
> do we release anything on subxact commit?  I though it was only on xact
> abort, and that does invalidate all the savepoints in between.

Yes, we free some things.  Granted it's not a lot, but we have stacks
for several things that will be always be growing with savepoints, but
we can chop their heads off with "commit nested."

-- 
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
Jason Tesser: You might not have understood me or I am not understanding you.
Paul Thomas: It feels like we're 2 people divided by a common language...



pgsql-hackers by date:

Previous
From: Dennis Bjorklund
Date:
Subject: Re: Nested Transactions, Abort All
Next
From: Thomas Swan
Date:
Subject: Re: Nested Transactions, Abort All