Horton

Re: [GENERAL] DECLARE CURSOR

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: snpe <snpe@snpe.co.yu>
Cc: Bruce Momjian <pgman@candle.pha.pa.us>, pgsql-hackers@postgresql.org
Date: 2002-11-18T14:38:59Z
Lists: pgsql-hackers 
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