Home > mailing lists

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

From	Jessica Richard
Subject	how to check objects dependency??
Date	October 31, 2007 15:46:47
Msg-id	906847.93368.qm@web56412.mail.re3.yahoo.com Whole thread Raw
Responses	Re: how to check objects dependency?? Re: how to check objects dependency?? Re: how to check objects dependency??
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:

From: "Scott Marlowe"
Date: 31 October 2007, 15:40:38
Subject: Re: Find who is connected to a database

From: yogesh
Date: 31 October 2007, 15:49:52
Subject: PL/JAVA issues

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

Previous

Next