Hi!
You cannot write such a script, but you will have to REVOKE and change ownership
and ALTER DEFAULT PRIVILEGES until no more dependencies on the role exist.
I ran script as superuser. In this case more detailed information appears:
ERROR: role "roletodelete" cannot be dropped because some
On Sun, 2020-04-12 at 00:25 +0300, Andrus wrote:
> User "currentuser" tries to delete role "roletodelete" from this database
> using
>
> But got error
>
> ERROR: role "roletodelete" cannot be dropped because some objects depend on it
> DETAIL: privileges for schema public;
>
> How to create s
