Tom Lane wrote:
> "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?

Is there anything to do on this item?

  Bruce Momjian  <[EMAIL PROTECTED]>

  + If your life is a hard drive, Christ can be your backup. +

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Reply via email to