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

Поиск
Список
Период
Сортировка
От Dennis Jenkins
Тема Re: PG-9.3.6, unable to "drop role because some objects depend on it"
Дата
Msg-id CAAEzAp8yOuAb8507+9VCO2G1BR9OeM2Zw6scG=L8-N6eW0cHHQ@mail.gmail.com
обсуждение исходный текст
Ответ на PG-9.3.6, unable to "drop role because some objects depend on it"  (Dennis Jenkins <dennis.jenkins.75@gmail.com>)
Список pgsql-general
Дерево обсуждения
Doh.  I found my answer.  Tome posted it years ago..
http://www.postgresql.org/message-id/18994.1325874130@sss.pgh.pa.us

I have to connect to the offending database and try to "drop role" again to get the list of actual objects.  One database cannot query the catalog of another.

On Mon, Apr 13, 2015 at 12:05 PM, Dennis Jenkins <dennis.jenkins.75@gmail.com> wrote:
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 по дате отправления:

Предыдущее
От: Dennis Jenkins
Дата:
Сообщение: Re: PG-9.3.6, unable to "drop role because some objects depend on it"
Следующее
От: "Day, David"
Дата:
Сообщение: Re: unexpected error " tables can have at most 1600 columns"