check_function_bodies: At least the description seems wrong, since we have prodedures

Поиск
Список
Период
Сортировка
Искать
От
Daniel Westermann (DWE)
Тема
check_function_bodies: At least the description seems wrong, since we have prodedures
Дата
Msg-id
GV0P278MB04834A9EB9A74B036DC7CE49D2739@GV0P278MB0483.CHEP278.PROD.OUTLOOK.COM
Список
Дерево обсуждения
check_function_bodies: At least the description seems wrong, since we have prodedures "Daniel Westermann (DWE)" <daniel.westermann@dbi-services.com>
Re: check_function_bodies: At least the description seems wrong, since we have prodedures Chapman Flack <chap@anastigmatix.net>
Re: check_function_bodies: At least the description seems wrong, since we have prodedures Tom Lane <tgl@sss.pgh.pa.us>
Re: check_function_bodies: At least the description seems wrong, since we have prodedures "Daniel Westermann (DWE)" <daniel.westermann@dbi-services.com>
Re: check_function_bodies: At least the description seems wrong, since we have prodedures Tom Lane <tgl@sss.pgh.pa.us>
Hi,

check_function_bodies has this description: 

postgres=# select short_desc from pg_settings where name = 'check_function_bodies';
                  short_desc                   
-----------------------------------------------
 Check function bodies during CREATE FUNCTION.
(1 row)

This is not the whole truth since we have procedures, as this affects CREATE PROCEDURE as well:

postgres=# create procedure p1 ( a int ) as $$ beginn null; end $$ language plpgsql;
ERROR:  syntax error at or near "beginn"
LINE 1: create procedure p1 ( a int ) as $$ beginn null; end $$ lang...
                                            ^
postgres=# set check_function_bodies = false;
SET
postgres=# create procedure p1 ( a int ) as $$ beginn null; end $$ language plpgsql;
CREATE PROCEDURE
postgres=# 

At least the description should mention procedures. Even the parameter name seems not to be correct anymore. Thoughts?

Regards
Daniel



В списке pgsql-hackers по дате отправления
От: David Steele
Дата:
От: Chapman Flack
Дата:
FAQ