Re: « 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... »
Дата
Msg-id 4DC7ED5B-BADD-4330-B481-76490D3B319E@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>)
Ответы Re: « The PL/pgSQL interpreter parses the function's source text and produces an internal binary instruction tree... »  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-general

This isn't a bug.

It's actually a feature…

Having said that, there are certainly aspects of what happens when in plpgsql that don't have a lot of justification other than being implementation artifacts…

Thanks, Tom. I'll take your « aspects of… plpgsql [are simply] implementation artifacts » to mean that my hope to understand what is checked at "create or replace <my subprogram>" time and what is checked first at runtime is futile.

There does seem to be a general rule. But, as my example shows, there are exceptions to the rule. And it's impossible to make a simple user-facing statement of what determines "exceptional" status.

I suppose that the conclusion is clear: you can't be sure that a subprogram is good until every single code path (in the basic block coverage sense of this) has been tested. But, anyway, it was ever thus. (Error-free compilation never did guarantee error-free runtime outcomes.)

I'll call this "case closed" then.

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

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