Re: [GENERAL] DECLARE CURSOR
snpe <snpe@snpe.co.yu>
From: Haris Peco <snpe@snpe.co.yu>
To: pgsql-hackers@postgresql.org
Date: 2002-11-18T17:36:00Z
Lists: 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