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 pgman@candle.pha.pa.us | (610)
359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square,
Pennsylvania19073