Re: Nested Transactions, Abort All

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.

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