Re: INFORMATION_SCHEMA.routines column routine_definition does not show the source

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: INFORMATION_SCHEMA.routines column routine_definition does not show the source
Дата
Msg-id CAKFQuwZaihWCaR4T=4Ov9ufk7jipRbBBtEDon61XMYOU6qkhxQ@mail.gmail.com
обсуждение исходный текст
Ответ на INFORMATION_SCHEMA.routines column routine_definition does not show the source  (Erki Eessaar <erki.eessaar@taltech.ee>)
Ответы Re: INFORMATION_SCHEMA.routines column routine_definition does not show the source  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
Дерево обсуждения
On Wed, Nov 3, 2021 at 7:49 AM Erki Eessaar <erki.eessaar@taltech.ee> wrote:
Unfortunately the bodies of such routines are not visible in the column routine_definition of the view INFORMATION_SCHEMA.routines. In case of these routines the field contains the empty string instead of the routine body.

Thanks for the report!

The information schema query consults pg_proc.prosrc directly instead of calling pg_get_functiondef(...) (which didn't exist when the original query was written, and hasn't been wrong until now).

David J.

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

Предыдущее
От: Erki Eessaar
Дата:
Сообщение: INFORMATION_SCHEMA.routines column routine_definition does not show the source
Следующее
От: Erki Eessaar
Дата:
Сообщение: pg_get_functiondef and aggregate functions