Re: Bug, Feature, or what else?

2013/2/8 Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>

> How can i drop a user as SUPERUSER (!) with all privileges?
>

According to the docs:
http://www.postgresql.org/docs/current/interactive/sql-droprole.html

> A role cannot be removed if it is still referenced in any database of the
cluster;
> an error will be raised if so. Before dropping the role, you must drop
all the objects
> it owns (or reassign their ownership) and revoke any privileges the role
has been
> granted. The REASSIGN OWNED<http://www.postgresql.org/docs/current/interactive/sql-reassign-owned.html>
and DROP OWNED<http://www.postgresql.org/docs/current/interactive/sql-drop-owned.html>
commands
can be useful for this purpose.

--
Victor Y. Yegorov