Re: Nested Transactions, Abort All

Bruce Momjian wrote:
> Dennis Bjorklund wrote:
> > On Sat, 10 Jul 2004, Josh Berkus wrote:
> > 
> > > In other words:
> > >     SAVEPOINT == BEGIN NESTED
> > >     RELEASE SAVEPOINT == COMMIT NESTED
> > >     ROLLBACK TO SAVEPOINT == ROLLBACK NESTED
> > 
> > Here it should be:
> > 
> >     ROLLBACK TO SAVEPOINT == ROLLBACK NESTED; SAVEPOINT;
> > 
> > And just to clearify, this is an extension to the spec that we then have
> > to support for a long time. Adding this now and then replacing it with the
> > standard syntax is not very sexy. If we add this we should support 
> > it "for ever".
> 
> Just to clarify, this is to allow rolling back to the same savepoint
> multiple times.  If we named savepoints, the new savepoint would be the
> same name as the one we just rolled back.

Sorry, I confused folks.  I should have corrected this line too:

> >     ROLLBACK TO SAVEPOINT == ROLLBACK NESTED; BEGIN NESTED;

It is not a non-standard behavior.  It is only an implementation detail
used internally that allows nested transactions to implement savepoints.

--  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