From: Bruce Momjian <bruce@momjian.us>
Message-Id: <201110111511.p9BFBYX17467@momjian.us>
Subject: Re: Discrepancy in 9.1 Documentation on CREATE ROLE
In-Reply-To: 
 <CA+TgmoZentW-XcJaSXLPN+2i0XebtU6BAKAB4JdtdFd2QBjiDQ@mail.gmail.com>
To: Robert Haas <robertmhaas@gmail.com>
Date: Tue, 11 Oct 2011 11:11: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 Tue, Oct 11, 2011 at 10:44 AM, Bruce Momjian <bruce@momjian.us> wrote:
> > 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.
> 
> They shouldn't appear in any non-ancient dumps, and we don't guarantee
> that those will work anyway: you're suppose to pg_dump with the new
> version of pg_dump, running against the old cluster.

Well, we have pg_dump support for 7.3 dumps (2002), so I don't see a
reason to remove that capability.  Now, if we want to remove that
support, then it would make sense to remove the rest, but I think people
are still assuming old dumps can load, especially if they have the dump
but not the 7.3 server installed.

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

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