| From: | "Daniel Westermann (DWE)" <daniel(dot)westermann(at)dbi-services(dot)com> |
|---|---|
| To: | PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | check_function_bodies: At least the description seems wrong, since we have prodedures |
| Date: | 2021-04-09 12:11:35 |
| Message-ID: | GV0P278MB04834A9EB9A74B036DC7CE49D2739@GV0P278MB0483.CHEP278.PROD.OUTLOOK.COM |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chapman Flack | 2021-04-09 13:21:42 | Re: check_function_bodies: At least the description seems wrong, since we have prodedures |
| Previous Message | David Steele | 2021-04-09 11:54:29 | Re: SQL:2011 PERIODS vs Postgres Ranges? |