how to check objects dependency??

Поиск
Список
Период
Сортировка
От Jessica Richard
Тема how to check objects dependency??
Дата
Msg-id 906847.93368.qm@web56412.mail.re3.yahoo.com
обсуждение исходный текст
Ответы 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>)
Список 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

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Scott Marlowe"
Дата:
Сообщение: Re: Find who is connected to a database
Следующее
От: yogesh
Дата:
Сообщение: PL/JAVA issues