Re: Discrepancy in 9.1 Documentation on CREATE ROLE - Mailing list pgsql-docs

From Ron Adams
Subject Re: Discrepancy in 9.1 Documentation on CREATE ROLE
Date
Msg-id CACMhA3nyx=iq8Vwf9K40i2064rPdy2YQqFsSETQpw5CXv64Pow@mail.gmail.com
Whole thread Raw
In response to Re: Discrepancy in 9.1 Documentation on CREATE ROLE  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-docs
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@gmail.com> wrote:
On Thu, Oct 6, 2011 at 10:48 PM, Ron Adams <ron@constellationmedia.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

pgsql-docs by date:

Previous
From: Robert Haas
Date:
Subject: Re: Discrepancy in 9.1 Documentation on CREATE ROLE
Next
From: Bruce Momjian
Date:
Subject: Re: Change to documentation headers