Re: [GENERAL] DECLARE CURSOR

From: Haris Peco <snpe(at)snpe(dot)co(dot)yu>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: [GENERAL] DECLARE CURSOR
Date: 2002-11-18 17:47:16
Message-ID: 200211181747.16226.snpe@snpe.co.yu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

On Monday 18 November 2002 05:38 pm, Bruce Momjian wrote:
> 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.
Fine.What about cursor out of a transaction ?
Thanks
Haris Peco

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruno Wolff III 2002-11-18 17:56:28 Re: Authorise root as postgres
Previous Message Bruce Momjian 2002-11-18 17:46:22 Re: [GENERAL] DECLARE CURSOR

Browse pgsql-hackers by date

  From Date Subject
Next Message Rudy Lippan 2002-11-18 17:55:08 Re: DBD::PostgreSQL
Previous Message Bruce Momjian 2002-11-18 17:46:22 Re: [GENERAL] DECLARE CURSOR