PostgreSQL version:

check_function_bodies

This parameter is normally on. When set to off, it disables validation of the function body string during sql-createfunction. Disabling validation avoids side effects of the validation process and avoids false positives due to problems such as forward references. Set this parameter to off before loading functions on behalf of other users; pg_dump does so automatically.

Recommendations

You only really want to turn this off to resolve circular dependancies, and that can be done on a per-session basis. In general, checking for syntax errors in PL/pgSQL functions is a very good idea.

Comments