Re: [GENERAL] Fun with Cursors- how to rewind a cursor - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [GENERAL] Fun with Cursors- how to rewind a cursor
Date
Msg-id 25786.1174864084@sss.pgh.pa.us
Whole thread Raw
In response to Re: [GENERAL] Fun with Cursors- how to rewind a cursor  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
I wrote:
> I'd venture that we should try to get rid of the restriction, but I'm
> unsure whether removing the error check is sufficient or whether there
> are real problems it's preventing.

I did a little experimentation and it seems that DECLARE CURSOR,
FETCH, and CLOSE work perfectly fine when executed through SPI
(after diking out the error check).  So I see no reason to have
that prohibition in place --- we may as well just take it out and
save a few lines of code.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Idea for cleaner representation of snapshots
Next
From: Tom Lane
Date:
Subject: Re: tsearch2 regression test failures