Postgres Pro
Downloads
Home   >   mailing lists

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

From Jessica Richard
Subject how to check objects dependency??
Date
Msg-id 906847.93368.qm@web56412.mail.re3.yahoo.com
Whole thread Raw
Responses Re: how to check objects dependency??  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Re: how to check objects dependency??  (Alvaro Herrera <alvherre@commandprompt.com>)
Re: how to check objects dependency??  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view
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?

Thanks,
Jessica

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

pgsql-admin by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: Find who is connected to a database
Next
From: yogesh
Date:
Subject: PL/JAVA issues