Rewrite previous commit's test for TestUpgradeXversion compatibility.
authorNoah Misch <noah@leadboat.com>
Sat, 23 Aug 2025 23:46:20 +0000 (16:46 -0700)
committerNoah Misch <noah@leadboat.com>
Sat, 23 Aug 2025 23:46:24 +0000 (16:46 -0700)
commit49a09c6c51c0d642e87086bbc7eb748c200d3f43
tree1fc5ae35224293d9e86a23b392ace10760300b38
parente8d22095e5df4d22513ce553998eef899f5f0692
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
src/test/regress/sql/privileges.sql