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.
(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
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
