PostgreSQL developers,
I am unable to drop a role with presumably no object dependencies or
connection access on my PostgreSQL 8.4.2 installation (64-bit OSX). Any
help would be greatly appreciated as I've spent way too much time trying
to execute a simple command.
template1=# DROP ROLE a485099;
ERROR: role "a485099" cannot be dropped because some objects depend on
it
DETAIL: access to database template1
template1=# \du a485099;
List of roles
Role name | Attributes | Member of
-----------+------------+-----------
a485099 | | {}
template1=# REVOKE CONNECT ON DATABASE template1 FROM a485099;
REVOKE
template1=# REASSIGN OWNED BY a485099 TO postgres;
REASSIGN OWNED
template1=# DROP OWNED BY a485099;
REASSIGN OWNED
template1=# DROP ROLE a485099;
ERROR: role "a485099" cannot be dropped because some objects depend on
it
DETAIL: access to database template1
What am I missing?
Thanks, Robert