Jessica Richard <rjessil(at)yahoo(dot)com> writes:
> I am trying to drop a user but it complained with the following message:
> ERROR: role "joe" cannot be dropped because some objects depend on it
> DETAIL: 1 objects in database Jan_test
> 1 objects in database Jan
> this user does not own any tables in those two databases. Is there any command I can use to check all the dependencies on this user?
Try to do the DROP ROLE within those databases. You'll get more detail
about owned objects within the current database, but from outside that
database the info isn't reachable ...
regards, tom lane