Re: Orphaned users in PG16 and above can only be managed by Superusers
От | Nathan Bossart |
---|---|
Тема | Re: Orphaned users in PG16 and above can only be managed by Superusers |
Дата | |
Msg-id | Z8ssFbYVaOE-fzMh@nathan обсуждение исходный текст |
Ответ на | Re: Orphaned users in PG16 and above can only be managed by Superusers (Ashutosh Sharma <ashu.coek88@gmail.com>) |
Ответы |
Re: Orphaned users in PG16 and above can only be managed by Superusers
|
Список | pgsql-hackers |
On Thu, Mar 06, 2025 at 04:10:10PM +0530, Ashutosh Sharma wrote: > Attached is the v2 patch with the following updates: > > 1) Added detailed comments atop check_drop_role_dependency() to > clarify role dependencies, addressing Nathan's comment. Thanks! > 2) Fixed a race condition where the dependency check could pass, but a > new dependency might be added before the role drop is completed, > addressing comments from Nathan and Robert. > > 3) Improved the error message to display the role dependencies in > detail, addressing feedback from Robert. > > Please have a look and let me know for any further comments. Thanks. I noticed that much of this code is lifted from DropRole(), and the new check_drop_role_dependency() function is only used by DropRole() right before it does the exact same scans. Couldn't we put the new dependency detection in those existing scans in DropRole()? -- nathan
В списке pgsql-hackers по дате отправления: