PG-9.3.6, unable to "drop role because some objects depend on it"

Поиск
Список
Период
Сортировка
От Dennis Jenkins
Тема PG-9.3.6, unable to "drop role because some objects depend on it"
Дата
Msg-id CAAEzAp8mA7fMt05ZkNVX37tn+aA=yD3TbikHR7o3XrekO9EbNw@mail.gmail.com
обсуждение исходный текст
Ответы Re: PG-9.3.6, unable to "drop role because some objects depend on it"  (Dennis Jenkins <dennis.jenkins.75@gmail.com>)
Список pgsql-general
Дерево обсуждения
I am attempting to remove a "role" from Postgresql-9.3.6.  I've already reassigned ownership for the role's tables, functions, sequences, types, views, etc...  However, I am still unable to remove the role.  Postgresql reports that "8 objects in the database 'postgres'" depend on this role.

How do I locate the database objects that depend on the 'DEADUSER' so that I can remedy the situation?

ps- I've tried "REASSIGN OWNED BY DEADUSER TO pgsql;" with no success.


(env vars set for PGDATABASE and PGUSER, target role name changed to protect the guilty)

# psql -c"drop role DEADUSER;"
ERROR:  role "DEADUSER" cannot be dropped because some objects depend on it
DETAIL:  8 objects in database postgres

# pg_dump --schema-only postgres | grep -i DEADUSER
## No results

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

Предыдущее
От: Ilya Ashchepkov
Дата:
Сообщение: Re: Hot standby problems: consistent state not reached, no connection to master server.
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Re: Hot standby problems: consistent state not reached, no connection to master server.