On Fri, Jul 09, 2004 at 07:10:06PM +0200, Dennis Bjorklund wrote: > On Fri, 9 Jul 2004, Bruce Momjian wrote: > > > I think we agreed on BEGIN NESTED/COMMIT NESTED, and START NESTED > > TRANSACTION and COMMIT NESTED TRANSACTION. > > Should I read this as pg will get its own implementation of sub > transactions and not implement the almost equivalent standard (sql99) > savepoint feature?
I think we should get both. Clearly savepoints do not allow for a snapshot to be released; nested xacts do. OTOH savepoints are trivial to implement once nested xacts are in place. They are only syntactic sugar. -- Alvaro Herrera (<alvherre[a]dcc.uchile.cl>) "Pensar que el espectro que vemos es ilusorio no lo despoja de espanto, sólo le suma el nuevo terror de la locura" (Perelandra, CSLewis) ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
