Re: [GENERAL] DECLARE CURSOR

Haris Peco wrote:
> On Monday 18 November 2002 03:45 pm, Bruce Momjian wrote:
> > Haris Peco wrote:
> > > On Monday 18 November 2002 02:38 pm, Tom Lane wrote:
> > > > snpe <snpe(at)snpe(dot)co(dot)yu> writes:
> > > > > is it planed cursor out of a transaction in 7.4 ?
> > > >
> > > > I do not think we will allow cross-transaction cursors ever. What
> > > > would it mean to have a cross-transaction cursor, anyway? Does it show
> > > > a frozen snapshot as of the time it was opened? The usefulness of that
> > > > seems awfully low in comparison to the pain of implementing it.
> > > >
> > > > regards, tom lane
> > >
> > > It is in TODO list. Can You implement this with savepoint ?
> >
> > I am planning on doing savepoints for 7.4.
>
> great.
> Is it possible with savepoints next :
> when am I in transaction and any command is error - only this command
> is lost and I continue normal ?

Yes, that will be part of it. I am working on my proposal today.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073