max_function_args

A preset configuration parameter reporting the maximum number of function arguments

max_function_args is a preset configuration parameter reporting the maximum number of function arguments, as defined by FUNC_MAX_ARGS when PostgreSQL was built.

max_function_args was added in PostgreSQL 8.0.

Default value

As of PostgreSQL 14, the default value for max_function_args (as defined by FUNC_MAX_ARGS) is: 100.

Notes

If PostgreSQL is compiled with FUNC_MAX_ARGS set to a value other than 100, any shared libraries such as those provided by extensions must be compiled against PostgreSQL with FUNC_MAX_ARGS set to that amount. Otherwise they will not be compatible and when attempting to install an error similar to the following will occur:

ERROR:  incompatible library "/usr/pgsql-13/lib/some_extension.so": magic block mismatch
DETAIL:  Server has FUNC_MAX_ARGS = 200, library has 100.

Change history

Categories

Functions and procedures, GUC configuration item, Preset configuration item

See also

max_identifier_length, max_index_keys