Re: CREATEROLE does not permit commenting on newly-created roles

Excerpts from Euler Taveira de Oliveira's message of mar mar 08 02:06:13 -0300 2011:
> Em 07-03-2011 16:53, Owen Jacobson escreveu:
> > psql:repro.sql:2: ERROR:  must be member of role "commented_role" to
> > comment upon it
> >
> This isn't a bug; let say it is a limitation (and a documented one [1]).
> Unfortunately only the role, superuser or its members can add/drop comments.

Maybe it would be good to have a COMMENT clause on the CREATE ROLE
command.  It would be inconsistent with the rest of the comment system,
but this privilege problem is inconsistent too.

--
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support