Alvaro Herrera wrote: > On Fri, Jul 09, 2004 at 03:34:47PM -0400, Bruce Momjian wrote: > > Alvaro Herrera wrote: > > > On Fri, Jul 09, 2004 at 09:07:58PM +0200, Dennis Bjorklund wrote: > > > > On Fri, 9 Jul 2004, Alvaro Herrera wrote: > > > > > > > > > Clearly savepoints do not allow for a snapshot to be released; nested > > > > > xacts do. > > > > > > > > Why not? > > > > > > What is it? > > > > Simon posted it. It is called RELEASE: > > We can't actually release anything (commit the subtransactions), because > they may be savepoints established after that point, and they are > logically "inside" the previously established ones. At RELEASE we can't > really release -- we just lose the name and thus the opportunity to > rollback to it.
Oh, good point. Yes, those savepoints in between are still active. But do we release anything on subxact commit? I though it was only on xact abort, and that does invalidate all the savepoints in between. -- 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 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly