Postgres Pro
Downloads
Home   >   mailing lists

Re: how to check objects dependency?? - Mailing list pgsql-admin

From Tom Lane
Subject Re: how to check objects dependency??
Date
Msg-id 18966.1193860699@sss.pgh.pa.us
Whole thread Raw
In response to how to check objects dependency??  (Jessica Richard <rjessil@yahoo.com>)
Responses Re: how to check objects dependency??  (Jessica Richard <rjessil@yahoo.com>)
List pgsql-admin
Tree view 
Jessica Richard <rjessil@yahoo.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
dependencieson 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

pgsql-admin by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: how to check objects dependency??
Next
From: "Scott Marlowe"
Date:
Subject: Re: Upgrading from 7.2.1 to 8.x