Make allow_system_table_mods settable at run time
authorPeter Eisentraut <peter@eisentraut.org>
Fri, 29 Nov 2019 09:04:45 +0000 (10:04 +0100)
committerPeter Eisentraut <peter@eisentraut.org>
Fri, 29 Nov 2019 09:22:13 +0000 (10:22 +0100)
commitc4a7a392ec8f0ff7701d84768080721ff8a7782e
tree9db396cfe5a4e7bdce99e19b0f319dad30b3b1e1
parent508bf95b767140ec1a339bcb53538d21deb9d995
Make allow_system_table_mods settable at run time

Make allow_system_table_mods settable at run time by superusers.  It
was previously postmaster start only.

We don't want to make system catalog DDL wide-open, but there are
occasionally useful things to do like setting reloptions or statistics
on a busy system table, and blocking those doesn't help anyone.  Also,
this enables the possibility of writing a test suite for this setting.

Reviewed-by: Tom Lane <tgl@sss.pgh.pa.us>
Discussion: https://www.postgresql.org/message-id/flat/8b00ea5e-28a7-88ba-e848-21528b632354%402ndquadrant.com
doc/src/sgml/config.sgml
src/backend/utils/misc/guc.c