Unable to drop role
От | McGehee, Robert |
---|---|
Тема | Unable to drop role |
Дата | |
Msg-id | EEBC169715EB8C438D3C9283AF0F201C08DF4C41@MSGBOSCLM2WIN.DMN1.FMR.COM обсуждение исходный текст |
Ответы |
Re: Unable to drop role
Re: Unable to drop role |
Список | pgsql-admin |
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 по дате отправления: