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

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: CREATEROLE does not permit commenting on newly-created roles
Дата
Msg-id 1299599930-sup-5129@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: CREATEROLE does not permit commenting on newly-created roles  (Euler Taveira de Oliveira <euler@timbira.com>)
Ответы Re: CREATEROLE does not permit commenting on newly-created roles  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Dan Ports
Дата:
Сообщение: Re: BUG #5918: SummarizeOldestCommittedSxact assertion failure
Следующее
От: Tom Lane
Дата:
Сообщение: Re: CREATEROLE does not permit commenting on newly-created roles