Skip site navigation (1)
Skip section navigation (2)
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
Peripheral Links
Header And Logo
|
Site Navigation
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: Wed, 31 Oct 2007 07:50:51 -0700 (PDT)
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
- Follow-Ups:
- Re: how to check objects dependency??
- From: Tom Lane
- Re: how to check objects dependency??
- From: Alvaro Herrera
- Re: how to check objects dependency??
- From: Scott Marlowe
- Re: how to check objects dependency??
- Prev by Date: Re: Find who is connected to a database
- Next by Date: Re: Postgresql Database Corrupted
- Previous by thread: PL/JAVA issues
- Next by thread: Re: how to check objects dependency??
- Indexes: