Re: Discrepancy in 9.1 Documentation on CREATE ROLE

Ah, makes sense! Thank you. And for what it's worth coming from someone
trying to pick all this up, I'd say that yes, it's rather confusing as is.

On Mon, Oct 10, 2011 at 13:34, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:

> On Thu, Oct 6, 2011 at 10:48 PM, Ron Adams <ron(at)constellationmedia(dot)com>
> wrote:
> > The help for LOGIN/NOLOGIN at
> > http://www.postgresql.org/docs/9.1/static/sql-createrole.html:
> "...NOLOGIN
> > is the default, except when CREATE ROLE is invoked through its
> alternative
> > spelling CREATE USER." The help for CREATE USER: "These clauses are an
> > obsolete, but still accepted, spelling of SUPERUSER and NOSUPERUSER. Note
> > that they are not equivalent to CREATEROLE as one might naively expect!"
> Eh?
>
> OK, brace yourself...
>
> You're mixing up the CREATEUSER option to the CREATE ROLE command with
> the completely separate command CREATE USER.
>
> See http://www.postgresql.org/docs/9.1/static/sql-createuser.html
>
> I wonder if we ought to consider removing CREATEUSER and NOCREATEUSER
> as synonyms for SUPERUSER and NOSUPERUSER. It looks like that change
> was made in 8.1, which is now EOL.
>
> --
> Robert Haas
> EnterpriseDB: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>