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
