Re: NO INHERIT

"Simon Riggs" <simon(at)2ndquadrant(dot)com> writes:
> On Tue, 2007-05-01 at 17:30 -0400, Tom Lane wrote:
>> "Simon Riggs" <simon(at)2ndquadrant(dot)com> writes:
>>> I notice that we have two versions of not INHERITing:
>>> ALTER ROLE meek NOINHERIT earth;
>>>
>>> ALTER TABLE meek NO INHERIT earth;
>>
>> Where are you reading that?

> http://developer.postgresql.org/pgdocs/postgres/sql-alterrole.html
> http://developer.postgresql.org/pgdocs/postgres/sql-altertable.html

Oh, you're complaining about the lack of parallelism between ALTER ROLE
and ALTER TABLE. They're not really that parallel anyway:

regression=# ALTER ROLE meek NOINHERIT earth;
ERROR: syntax error at or near "earth"
LINE 1: ALTER ROLE meek NOINHERIT earth;
^
regression=#

It's actually "ALTER ROLE meek NOINHERIT", which is spelled that way
because user/role related options have always been spelled that way:
http://www.postgresql.org/docs/6.4/static/sql-createuser.htm
Maybe we'd do it differently if we were starting over, but I don't
see a point in changing it now.

regards, tom lane