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?
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
pgsql-admin by date
|Next:||From: Scott Marlowe||Date: 2007-10-31 15:07:16|
|Subject: Re: Postgresql Database Corrupted|
|Previous:||From: Scott Marlowe||Date: 2007-10-31 14:42:13|
|Subject: Re: Find who is connected to a database|