Toggle navigation
Type: bool
Default: on
Context: user
Restart: false

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.


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.