pgsql: Remove old RULE privilege completely.

From: Fujii Masao <fujii(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Remove old RULE privilege completely.
Date: 2024-09-12 10:35:28
Message-ID: E1sohAe-000jSc-O3@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Remove old RULE privilege completely.

The RULE privilege for tables was removed in v8.2, but for backward
compatibility, GRANT/REVOKE and privilege functions like
has_table_privilege continued to accept the RULE keyword without
any effect.

After discussions on pgsql-hackers, it was agreed that this compatibility
is no longer needed. Since it's been long enough since the deprecation,
we've decided to fully remove support for RULE privilege,
so GRANT/REVOKE and privilege functions will no longer accept it.

Author: Fujii Masao
Reviewed-by: Nathan Bossart
Discussion: https://postgr.es/m/976a3581-6939-457f-b947-fc3dc836c083@oss.nttdata.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/fefa76f70fdc75c91f80bddce2df7a8825205962

Modified Files
--------------
src/backend/catalog/aclchk.c | 2 --
src/backend/utils/adt/acl.c | 6 ------
src/test/regress/expected/privileges.out | 9 ---------
src/test/regress/sql/privileges.sql | 4 ----
4 files changed, 21 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message David Rowley 2024-09-12 10:37:18 pgsql: Doc: alphabetize aggregate function table
Previous Message Peter Eisentraut 2024-09-12 09:17:30 pgsql: Don't overwrite scan key in systable_beginscan()