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: > BEGIN; > SAVEPOINT x1; > INSERT INTO ...; > RELEASE SAVEPOINT x1; > SAVEPOINT x1; > INSERT INTO ...; > RELEASE SAVEPOINT x1; > SAVEPOINT x1; > INSERT INTO ...; > RELEASE SAVEPOINT x1; -- 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 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
