From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
---|---|
To: | "McGehee, Robert" <robert(dot)mcgehee(at)geodecapital(dot)com> |
Cc: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Unable to drop role |
Date: | 2010-08-23 22:22:18 |
Message-ID: | 1282602055-sup-6731@alvh.no-ip.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-hackers |
Excerpts from McGehee, Robert's message of lun ago 23 13:29:47 -0400 2010:
> 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
So what does \l say about template1?
> template1=# REASSIGN OWNED BY a485099 TO postgres;
> template1=# DROP OWNED BY a485099;
IIRC neither REASSIGN OWNED nor DROP OWNED do anything about access to
databases.
--
Álvaro Herrera <alvherre(at)commandprompt(dot)com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Grittner | 2010-08-23 22:41:59 | Re: WAL and archive disks full |
Previous Message | Kieren Scott | 2010-08-23 22:16:22 | Re: WAL and archive disks full |
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2010-08-23 22:36:23 | Re: WIP: extensible enums |
Previous Message | David E. Wheeler | 2010-08-23 21:34:12 | Re: WIP: extensible enums |