postgres.git / summary / log / commit / refs

commit    fb75e1ef72123476209a4cd5b511f1b9e3c240f2
Author:   Noah Misch <noah@leadboat.com>
Date:     Sat Aug 23 23:46:20 2025 +0000
First released in: 13.23, 14.20, 15.15, 16.11, 17.7, 18.0

    Rewrite previous commit's test for TestUpgradeXversion compatibility.
    
    v17 introduced the MAINTAIN ON TABLES privilege.  That changed the
    applicable "baseacls" reaching buildACLCommands().  That yielded
    spurious TestUpgradeXversion diffs.  Change to use a TYPES privilege.
    Types have the same one privilege in all supported versions, so they
    avoid the problem.  Per buildfarm.  Back-patch to v13, like that commit.
    
    Discussion: https://postgr.es/m/20250823144505.88.nmisch@google.com
    Backpatch-through: 13


 src/test/regress/expected/privileges.out | 4 ++--
 src/test/regress/sql/privileges.sql      | 4 ++--
 2 files changed, 4 insertions(+), 4 deletions(-)

diff --git a/src/test/regress/expected/privileges.out b/src/test/regress/expected/privileges.out
index 9f3cb6b26aa..0f6b1d192e9 100644
--- a/src/test/regress/expected/privileges.out
+++ b/src/test/regress/expected/privileges.out
@@ -2377,9 +2377,9 @@ DROP USER regress_priv_user6;
 ERROR:  role "regress_priv_user6" does not exist
 -- leave some default ACLs for pg_upgrade's dump-restore test input.
 ALTER DEFAULT PRIVILEGES FOR ROLE pg_signal_backend
-	REVOKE INSERT ON TABLES FROM pg_signal_backend;
+	REVOKE USAGE ON TYPES FROM pg_signal_backend;
 ALTER DEFAULT PRIVILEGES FOR ROLE pg_read_all_settings
-	REVOKE INSERT ON TABLES FROM pg_read_all_settings;
+	REVOKE USAGE ON TYPES FROM pg_read_all_settings;
 -- permissions with LOCK TABLE
 CREATE USER regress_locktable_user;
 CREATE TABLE lock_table (a int);
diff --git a/src/test/regress/sql/privileges.sql b/src/test/regress/sql/privileges.sql
index 5454a39bc3d..731bdb2aec5 100644
--- a/src/test/regress/sql/privileges.sql
+++ b/src/test/regress/sql/privileges.sql
@@ -1449,9 +1449,9 @@ DROP USER regress_priv_user6;
 
 -- leave some default ACLs for pg_upgrade's dump-restore test input.
 ALTER DEFAULT PRIVILEGES FOR ROLE pg_signal_backend
-	REVOKE INSERT ON TABLES FROM pg_signal_backend;
+	REVOKE USAGE ON TYPES FROM pg_signal_backend;
 ALTER DEFAULT PRIVILEGES FOR ROLE pg_read_all_settings
-	REVOKE INSERT ON TABLES FROM pg_read_all_settings;
+	REVOKE USAGE ON TYPES FROM pg_read_all_settings;
 
 
 -- permissions with LOCK TABLE


[parent: 05341b2e9914]