"Postgres User" <[EMAIL PROTECTED]> writes:
> On 3/1/07, Tom Lane <[EMAIL PROTECTED]> wrote:
>> "Postgres User" <[EMAIL PROTECTED]> writes:
>>> <before opening cursor>     ref_entry = 'c_entry';
>>> <after looping thru cursor>  MOVE Backward All In c_entry;
>> You have to use EXECUTE for the latter.

> I had tried several variations of MOVE Backward inside an Execute
> statement earlier.  And now, I'm seeing this error appear again:
> ERROR: 0A000: cannot manipulate cursors directly in PL/pgSQL

Hm, you're right.  This arises from the fact that _SPI_execute_plan
rejects cursor-related utility statements.  While I'd never stopped
to question that before, it does seem like this restriction is a
bit pointless.  Does anyone remember why it's like that?

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [EMAIL PROTECTED] so that your
       message can get through to the mailing list cleanly

Reply via email to