Re: WIP: updatable cursors in plpgsql

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