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

From Bruce Momjian
Subject Re: Nested Transactions, Abort All
Date
Msg-id 200407091934.i69JYm327374@candle.pha.pa.us
Whole thread Raw
In response to Re: Nested Transactions, Abort All  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
Responses Re: Nested Transactions, Abort All
Re: Nested Transactions, Abort All
List pgsql-hackers
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:

> BEGIN;
>       SAVEPOINT x1;
>       INSERT INTO ...;
>       RELEASE SAVEPOINT x1;
>       SAVEPOINT x1;
>       INSERT INTO ...;
>       RELEASE SAVEPOINT x1;
>       SAVEPOINT x1;
>       INSERT INTO ...;
>       RELEASE SAVEPOINT x1;

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


pgsql-hackers by date:

Previous
From: elein
Date:
Subject: Re: [BUGS] BUG #1118: Misleading Commit message
Next
From: Bruce Momjian
Date:
Subject: Re: pg_dump 7.4 bug