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. -- Alvaro Herrera (<alvherre[a]dcc.uchile.cl>) Major Fambrough: You wish to see the frontier? John Dunbar: Yes sir, before it's gone. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster