Re: [GENERAL] DECLARE CURSOR - Mailing list pgsql-hackers

From Haris Peco
Subject Re: [GENERAL] DECLARE CURSOR
Date
Msg-id 200211181736.00277.snpe@snpe.co.yu
Whole thread Raw
In response to Re: [GENERAL] DECLARE CURSOR  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: [GENERAL] DECLARE CURSOR  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
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@snpe.co.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 ?

Thanks
Haris Peco



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: CLUSTER ALL syntax
Next
From: Bruce Momjian
Date:
Subject: Re: [GENERAL] DECLARE CURSOR