diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/create_role.out C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/create_role.out --- C:/cirrus/src/test/regress/expected/create_role.out 2025-11-25 02:28:36.733832400 +0000 +++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/create_role.out 2025-11-25 02:34:47.605887900 +0000 @@ -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