Re: WIP: updatable cursors in plpgsql - Mailing list pgsql-patches

From Pavel Stehule
Subject Re: WIP: updatable cursors in plpgsql
Date
Msg-id 162867790706110845l3d120b41lb171558ee968674a@mail.gmail.com
Whole thread Raw
In response to Re: WIP: updatable cursors in plpgsql  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: WIP: updatable cursors in plpgsql  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-patches
>
> 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

pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: WIP: updatable cursors in plpgsql
Next
From: Tom Lane
Date:
Subject: Re: WIP: updatable cursors in plpgsql