我尝试删除一个名为'xyz'的角色,该角色先前是同名模式的所有者。 我修改了模式所有权如下,并重新分配了所有权以防万一(尽管所有表都由具有超级用户权限的不同用户创建)。 所以我运行了以下所有命令:
alter schema xyz owner to postgres;
reassign owned by xyz to postgres;
alter default privileges in schema seeds revoke all on tables from xyz cascade;
alter default privileges in schema seeds revoke all on sequences from xyz cascade;
alter default privileges in schema seeds revoke all on functions from xyz cascade;
仍然出现错误:
drop role xyz;
ERROR: role "xyz" cannot be dropped because some objects depend on it
DETAIL: owner of default privileges on new relations belonging to role xyz in schema xyz
另外提供信息:
postgres=# \du rsi
List of roles
Role name | Attributes | Member of
-----------+----------------+-----------
rsi | No inheritance | {}
我错过了什么?任何帮助都将不胜感激!谢谢!