"Simon Riggs" <[EMAIL PROTECTED]> writes: > On Tue, 2007-05-01 at 17:30 -0400, Tom Lane wrote: >> "Simon Riggs" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
