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