Re: search_path for PL/pgSQL functions partially cached?

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: search_path for PL/pgSQL functions partially cached?
Дата
Msg-id CAKFQuwYTsfYmw9TNiXH=r2WUvDo7QpS+jtYAxK3an2OG7anpMA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: search_path for PL/pgSQL functions partially cached?  (Jan Behrens <jbe-mlist@magnetkern.de>)
Список pgsql-general
On Saturday, January 4, 2025, Jan Behrens <jbe-mlist@magnetkern.de> wrote:

I re-read section 41.11.2. on Plan Caching:

"The PL/pgSQL interpreter parses the function's source text and
produces an internal binary instruction tree the first time the
function is called (within each session). The instruction tree fully
translates the PL/pgSQL statement structure,

The type of a plpgsql variable is by definition its structure; established in a statement, so this is actually covered by that paragraph.  But I would be for adding a bit more specific terminology here.

David J.

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