Unable to drop role

From: "McGehee, Robert" <Robert(dot)McGehee(at)geodecapital(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Unable to drop role
Date: 2010-08-23 17:29:47
Message-ID: EEBC169715EB8C438D3C9283AF0F201C08DF4C41@MSGBOSCLM2WIN.DMN1.FMR.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-hackers

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message fazool mein 2010-08-23 19:07:54 Error while setting up streaming replication, postgres 9.0-beta 4
Previous Message Joshua D. Drake 2010-08-23 16:02:31 Re: pgBouncer for connection pooling

Browse pgsql-hackers by date

  From Date Subject
Next Message Josh Berkus 2010-08-23 17:30:34 Re: Return of the Solaris vacuum polling problem -- anyone remember this?
Previous Message David E. Wheeler 2010-08-23 16:56:00 Re: WIP: extensible enums