diff -U3 /Users/admin/pgsql/src/test/regress/expected/create_role.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/create_role.out --- /Users/admin/pgsql/src/test/regress/expected/create_role.out 2025-11-25 02:29:11 +++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/create_role.out 2025-11-25 02:33:04 @@ -219,6 +219,8 @@ DROP ROLE regress_nosuch_admin_recursive; ERROR: role "regress_nosuch_admin_recursive" does not exist DROP ROLE regress_plainrole; +ERROR: permission denied to drop role +DETAIL: Only roles with the CREATEROLE attribute and the ADMIN option on role "regress_plainrole" may drop this role. -- must revoke privileges before dropping role REVOKE CREATE ON DATABASE regression FROM regress_createrole CASCADE; -- ok, should be able to drop non-superuser roles we created