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