Re: PL/pgSQL cursors should get generated portal names by default

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: PL/pgSQL cursors should get generated portal names by default
Дата
Msg-id 2504191.1667605599@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: PL/pgSQL cursors should get generated portal names by default  (Jan Wieck <jan@wi3ck.info>)
Ответы Re: PL/pgSQL cursors should get generated portal names by default  (Jan Wieck <jan@wi3ck.info>)
Список pgsql-hackers
Jan Wieck <jan@wi3ck.info> writes:
> I need to do some testing on this. I seem to recall that the naming was 
> originally done because a reference cursor is basically a named cursor 
> that can be handed around between functions and even the top SQL level 
> of the application. For the latter to work the application needs to know 
> the name of the portal.

Right.  With this patch, it'd be necessary to hand back the actual
portal name (by returning the refcursor value), or else manually
set the refcursor value before OPEN to preserve the previous behavior.
But as far as I saw, all our documentation examples show handing back
the portal name, so I'm hoping most people do it like that already.

> I am currently down with Covid and have trouble focusing. But I hope to 
> get to it some time next week.

Get well soon!

            regards, tom lane



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Jan Wieck
Дата:
Сообщение: Re: PL/pgSQL cursors should get generated portal names by default
Следующее
От: Justin Pryzby
Дата:
Сообщение: Re: CI and test improvements