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 [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
