Re: « The PL/pgSQL interpreter parses the function's source text and produces an internal binary instruction tree... »

Поиск
Список
Период
Сортировка
От Christophe Pettus
Тема Re: « The PL/pgSQL interpreter parses the function's source text and produces an internal binary instruction tree... »
Дата
Msg-id 14BAC5B9-225E-49A8-A225-60C2F179E334@thebuild.com
обсуждение исходный текст
Ответ на « The PL/pgSQL interpreter parses the function's source text and produces an internal binary instruction tree... »  (Bryn Llewellyn <bryn@yugabyte.com>)
Ответы Re: « The PL/pgSQL interpreter parses the function's source text and produces an internal binary instruction tree... »  (Bryn Llewellyn <bryn@yugabyte.com>)
Re: Re: « The PL/pgSQL interpreter parses the function's source text and produces an internal binary instruction tree... »  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general

> On Jul 28, 2022, at 18:04, Bryn Llewellyn <bryn@yugabyte.com> wrote:
> Is this expected?

Yes.  This isn't a bug.

> In other words, is there a careful explanation of what "parse" means in the context of "create or replace" for a
subprogramthat predicts all of the outcomes that I reported here? 


Database objects (such as tables and columns) are left as identifiers until they are executed, because that is the
pointat which a plan for those statements is created.  The other components of PL/pgSQL are translated to internal form
(andthus checked for existence) as compile time. 


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

Предыдущее
От: Bryn Llewellyn
Дата:
Сообщение: « The PL/pgSQL interpreter parses the function's source text and produces an internal binary instruction tree... »
Следующее
От: Bryn Llewellyn
Дата:
Сообщение: Re: « The PL/pgSQL interpreter parses the function's source text and produces an internal binary instruction tree... »