how to check objects dependency??

From: Jessica Richard <rjessil(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: how to check objects dependency??
Date: 2007-10-31 14:50:51
Message-ID: 906847.93368.qm@web56412.mail.re3.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Marlowe 2007-10-31 15:07:16 Re: Postgresql Database Corrupted
Previous Message Scott Marlowe 2007-10-31 14:42:13 Re: Find who is connected to a database