Re: I can't drop a user if I don't drop his grants beforehand?????????????????? - Mailing list pgsql-general

Nico Sabbi wrote:
> Hi,
> i can't believe my eyes. Why on earth I can't drop a user without
> previously revoking his privileges?
> This is really _crazy_ in my opinion.
>
> I'm not speaking of object ownership, but of GRANTs.

As Tom says, it's a known limitation.  Did you try REASSIGN OWNED and/or DROP
OWNED?

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.