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:17:00 |
Message-ID: | CAAEzAp86izWJmZzYJsAqnAtb=xYtOMY_4dF8Tp3NtGxBiDYTEw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Apologies for the typo of your name in my last post, Tom.
On Mon, Apr 13, 2015 at 12:16 PM, Dennis Jenkins <
dennis(dot)jenkins(dot)75(at)gmail(dot)com> wrote:
> 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
>>
>>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Day, David | 2015-04-13 17:46:28 | Re: unexpected error " tables can have at most 1600 columns" |
Previous Message | Dennis Jenkins | 2015-04-13 17:16:31 | Re: PG-9.3.6, unable to "drop role because some objects depend on it" |