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:20 +0000 (16:46 -0700)
commitad4412480d3ff475a6dfa4a7f449702eff78312d
treeb102271bcb23831f2266190c128582ecd4627000
parentb61a5c4bed7df87120df587731840e51ea7c7525
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