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]> http://momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend