From: Bruce Momjian <bruce@momjian.us>
Message-Id: <201110111444.p9BEiYL14010@momjian.us>
Subject: Re: Discrepancy in 9.1 Documentation on CREATE ROLE
In-Reply-To: 
 <CA+TgmoafQga7wwv0wFj3KUqTa_=3GbEzgzOgONHPqVoG9KC2qg@mail.gmail.com>
To: Robert Haas <robertmhaas@gmail.com>
Date: Tue, 11 Oct 2011 10:44:34 -0400 (EDT)
CC: Ron Adams <ron@constellationmedia.com>, pgsql-docs@postgresql.org
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset="US-ASCII"

Robert Haas 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.

Agreed.  They might still appear in dumps so maybe just remove
documentation about them.

-- 
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +