Re: DROP ROLE prevented by dependency

"Bulgrien, Kevin" <Kevin(dot)Bulgrien(at)GDSATCOM(dot)com> writes:
> psql 8.3.16
> I've done some searching of mailing list, etc., but have either not searched
> the right way, or something. If anyone could throw a bone on this it would
> be appreciated. I have no idea what the procedure is for figuring out how
> to drop this role:

> DROP ROLE myuser;
> ERROR: role "myuser" cannot be dropped because some objects depend on it
> DETAIL: 1 objects in database postgres

Try the command while connected to the postgres database. It can't give
you more detail than that from where you are, for lack of visibility
into the other database's system catalogs.

Also, read up on DROP OWNED BY.

regards, tom lane