• Browse categories
• PostgreSQL releases
  • PostgreSQL 15 (beta1)
  • PostgreSQL 14 (latest)
  • PostgreSQL 13
  • PostgreSQL 12
  • PostgreSQL 11
  • PostgreSQL 10
  • PostgreSQL 9.6 (EOL)

Version charts

Useful overviews

Useful links

allow_system_table_mods

allow_system_table_mods is a configuration parameter determining whether system catalogue tables can be modified.

allow_system_table_mods was added in PostgreSQL 8.2.

Default value

The default value for allow_system_table_mods is: false.

Change history

• PostgreSQL 13
  • allow_system_table_mods can now be be set after server start (commit c4a7a392)
  • non-superusers prevented from modifiying the contents of system catalog tables (commit 508bf95b)
• PostgreSQL 8.2
  
  • added (commit 86c23a6e)

Examples

postgres=# SHOW allow_system_table_mods;
 allow_system_table_mods 
-------------------------
 on
(1 row)

postgres=# UPDATE pg_class SET relname='pg_foo' WHERE relname='pg_class';
UPDATE 1

postgres=# \dt
ERROR:  relation "pg_catalog.pg_class" does not exist
LINE 5: FROM pg_catalog.pg_class c
             ^

References

Categories