Re: WIP: updatable cursors in plpgsql

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: WIP: updatable cursors in plpgsql
Дата
Msg-id 162867790706110845l3d120b41lb171558ee968674a@mail.gmail.com
обсуждение исходный текст
Ответ на Re: WIP: updatable cursors in plpgsql  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: WIP: updatable cursors in plpgsql  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: WIP: updatable cursors in plpgsql
Следующее
От: Tom Lane
Дата:
Сообщение: Re: WIP: updatable cursors in plpgsql