Alvaro Herrera wrote: > On Sun, Jul 11, 2004 at 03:15:46PM -0700, Josh Berkus wrote: > > > For that matter: > > > > begin; > > savepoint; > > select 0/0; -- abort > > savepoint; -- commands will be ignored > > select 1; -- commands will be ignored > > release; -- commands will be ignored > > release; -- abort main xact 'cause we didn't rollback > > commit; -- abort message > > > > Is the above more or less correct, Alvaro? > > Save a minor detail. It would be > > begin; > savepoint; > select 0/0; -- abort > savepoint; -- commands will be ignored > select 1; -- commands will be ignored > release; -- commands will be ignored > release; -- commands will be ignored > commit; -- abort message > > Note that I'm trying to tell you something with the indenting; all those > commands are inside one and the same subtransaction. > > And I'm not planning to do anonymous savepoint. Do these buy us > anything?
Don't bother if you can do named ones. -- 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 8: explain analyze is your friend
