Re: CREATEROLE does not permit commenting on newly-created roles - Mailing list pgsql-bugs

From Alvaro Herrera
Subject Re: CREATEROLE does not permit commenting on newly-created roles
Date
Msg-id 1299599930-sup-5129@alvh.no-ip.org
Whole thread Raw
In response to Re: CREATEROLE does not permit commenting on newly-created roles  (Euler Taveira de Oliveira <euler@timbira.com>)
Responses Re: CREATEROLE does not permit commenting on newly-created roles  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: Dan Ports
Date:
Subject: Re: BUG #5918: SummarizeOldestCommittedSxact assertion failure
Next
From: Tom Lane
Date:
Subject: Re: CREATEROLE does not permit commenting on newly-created roles