Make allow_system_table_mods settable at run time

Peter Eisentraut <peter@eisentraut.org>

Commit: c4a7a392ec8f0ff7701d84768080721ff8a7782e
Author: Peter Eisentraut <peter@eisentraut.org>
Date: 2019-11-29T09:22:13Z
Releases: 13.0
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

Files

PathChange+/−
doc/src/sgml/config.sgml modified +5 −3
src/backend/utils/misc/guc.c modified +1 −1

Documentation touched

Discussion