Unable to drop role
От
McGehee, Robert
Тема
Unable to drop role
Дата
Msg-id
EEBC169715EB8C438D3C9283AF0F201C08DF4C41@MSGBOSCLM2WIN.DMN1.FMR.COM
Список
Дерево обсуждения
Re: Unable to drop role "McGehee, Robert" <Robert.McGehee@geodecapital.com>
Re: Unable to drop role Tom Lane <tgl@sss.pgh.pa.us>
Re: Unable to drop role Alvaro Herrera <alvherre@commandprompt.com>
Re: Unable to drop role Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] Unable to drop role Robert Haas <robertmhaas@gmail.com>
Re: Unable to drop role Tom Lane <tgl@sss.pgh.pa.us>
Re: Unable to drop role Alvaro Herrera <alvherre@commandprompt.com>
Re: Unable to drop role Alex Hunsaker <badalex@gmail.com>
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
В списке pgsql-admin по дате отправления
