Re: NO INHERIT

"Simon Riggs" <simon@2ndquadrant.com> writes:
> On Tue, 2007-05-01 at 17:30 -0400, Tom Lane wrote:
>> "Simon Riggs" <simon@2ndquadrant.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