Horton

Disallow dropping rules on system tables by default

Peter Eisentraut <peter@eisentraut.org>

View on postgr.es
Commit: df7fe9e2d707da69a4437fb6f9e695c070882160
Author: Peter Eisentraut <peter@eisentraut.org>
Date: 2019-12-20T07:27:37Z
Releases: 13.0 
Disallow dropping rules on system tables by default

This was previously not covered by allow_system_table_mods, but now it
is.  The impact in practice is probably low, but this makes it
consistent with most other DDL commands.

Reviewed-by: Robert Haas <robertmhaas@gmail.com>
Discussion: https://www.postgresql.org/message-id/flat/ee9df1af-c0d8-7c82-5be7-39ce4e3b0a9d%402ndquadrant.com

Files

PathChange+/−
src/backend/rewrite/rewriteRemove.c modified +8 −0
src/test/modules/unsafe_tests/expected/alter_system_table.out modified +10 −1
src/test/modules/unsafe_tests/sql/alter_system_table.sql modified +9 −1

Discussion