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

From: Dennis Jenkins <dennis(dot)jenkins(dot)75(at)gmail(dot)com>
To: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Re: PG-9.3.6, unable to "drop role because some objects depend on it"
Date: 2015-04-13 17:16:31
Message-ID: CAAEzAp8yOuAb8507+9VCO2G1BR9OeM2Zw6scG=L8-N6eW0cHHQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)jenkins(dot)75(at)gmail(dot)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
>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dennis Jenkins 2015-04-13 17:17:00 Re: PG-9.3.6, unable to "drop role because some objects depend on it"
Previous Message Adrian Klaver 2015-04-13 17:06:05 Re: Re: Hot standby problems: consistent state not reached, no connection to master server.