Re: Possible mismatch between behaviour and documentation in CREATE FUNCTION

On Friday, April 10, 2026, Isaac Morland <isaac(dot)morland(at)gmail(dot)com> wrote:

> The documentation says that only BEGIN ATOMIC parses the function body at
> definition time. Whereas AS parses the function body at execution time:
>
> https://www.postgresql.org/docs/current/sql-createfunction.html
>
> (and look at the explanation of sql_body)
>

Possibly some documentation tweaks are in order. I haven’t looked at it in
depth. The optional checks are able to be disabled:

https://www.postgresql.org/docs/current/runtime-config-client.html#RUNTIME-CONFIG-CLIENT-STATEMENT

While the result of the required parsing of a function body is implying
that such parsing is saved to the catalogs so that creation-time object
references are retained. While the others are re-parsed during execution
and object references retained only for the lifetime of the query.

David J.