Re: WIP: updatable cursors in plpgsql

From: "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: WIP: updatable cursors in plpgsql
Date: 2007-06-11 15:45:14
Message-ID: 162867790706110845l3d120b41lb171558ee968674a@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2007-06-11 16:20:22 Re: WIP: updatable cursors in plpgsql
Previous Message Tom Lane 2007-06-11 15:20:15 Re: COPYable logs status