Re: Nested Transactions, Abort All

On Sat, 10 Jul 2004, Bruce Momjian wrote:

> > > >     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".
> 
> Sorry, I confused folks.  I should have corrected this line too:
> 
> > >     ROLLBACK TO SAVEPOINT == ROLLBACK NESTED; BEGIN NESTED;

Hmm, yes. Correct.

Luckily, we already had: SAVEPOINT == BEGIN NESTED so it all worked out 
:-)

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

The non-standard part I was talking about was the savepoints without
names, and that is what we should support for ever if we introduce them. 

-- 
/Dennis Björklund