Orphaned users in PG16 and above can only be managed by Superusers

[grantzhou]

--- As of 2026-02-03T22:35:42.000Z ---

Álvaro Herrera inquires about the status of a discussion regarding extending DROP ROLE syntax to include CASCADE/RESTRICT options from the latest SQL standard. The conversation previously established that implementing CASCADE for dependent objects across multiple databases is not feasible, while RESTRICT is already the default behavior. The proposed approach focuses on handling dependent roles rather than database objects like tables and views that span multiple databases. Álvaro notes there is a stale commitfest entry (patch 5608) that remains open and questions whether it should be classified as a bug fix, seeking clarification on the current plan for this feature implementation.

Álvaro Herrera询问关于扩展DROP ROLE语法以包含来自最新SQL标准的CASCADE/RESTRICT选项的讨论状态。之前的对话确定了为跨多个数据库的依赖对象实现CASCADE是不可行的，而RESTRICT已经是默认行为。提议的方法专注于处理依赖角色，而不是跨多个数据库的表、视图等数据库对象。Álvaro注意到有一个过期的commitfest条目（补丁5608）仍然处于开放状态，并质疑是否应该将其归类为错误修复，寻求对此功能实现当前计划的澄清。

participants - 参与者:

• alvherre@kurilemu.de
• andres@anarazel.de
• andrew@dunslane.net
• ashu.coek88@gmail.com
• nathandbossart@gmail.com
• robertmhaas@gmail.com
• tgl@sss.pgh.pa.us
• tomas@vondra.me