View Single Post

   
  #4 (permalink)  
Old 04-18-2008, 11:13 AM
Pavel Stehule
 
Posts: n/a
Default Re: WIP: updatable cursors in plpgsql

>
> No, the question is what is the patch trying to accomplish, because
> as far as I can see it's wrong. It seems to be trying to insert the
> plpgsql name of the cursor, which is not necessarily the SQL name.
>



All explicit cursors (what I know) use named SQL cursors. SQL name is
checked in OPEN statement. Refcursors are problematic. But refcursors
are not updatable.

We have to check this case and raise error. It's correct - holdable
cursors aren't updatable. It's WIP patch

Regards
Pavel Stehule

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Reply With Quote