Re: [DOCS] Discrepancy in 9.1 Documentation on CREATE ROLE

2011-10-12 Thread Robert Haas
On Wed, Oct 12, 2011 at 12:59 AM, Tom Lane wrote: > Robert Haas writes: >> On Tue, Oct 11, 2011 at 11:59 AM, Tom Lane wrote: >>> I think removing them from the docs but continuing to accept them makes >>> sense.  We do still hear from people migrating from 7.4 or older, and >>> it's not always g

Re: [DOCS] Discrepancy in 9.1 Documentation on CREATE ROLE

2011-10-11 Thread Tom Lane
Robert Haas writes: > On Tue, Oct 11, 2011 at 11:59 AM, Tom Lane wrote: >> I think removing them from the docs but continuing to accept them makes >> sense.  We do still hear from people migrating from 7.4 or older, and >> it's not always going to be practical for them to make a dump with a >> ne

Re: [DOCS] Discrepancy in 9.1 Documentation on CREATE ROLE

2011-10-11 Thread Robert Haas
On Tue, Oct 11, 2011 at 11:59 AM, Tom Lane wrote: > Bruce Momjian writes: >> Robert Haas wrote: >>> On Tue, Oct 11, 2011 at 10:44 AM, Bruce Momjian wrote: Robert Haas wrote: > I wonder if we ought to consider removing CREATEUSER and NOCREATEUSER > as synonyms for SUPERUSER and NOSUP

Re: [DOCS] Discrepancy in 9.1 Documentation on CREATE ROLE

2011-10-11 Thread Tom Lane
Bruce Momjian writes: > Robert Haas wrote: >> On Tue, Oct 11, 2011 at 10:44 AM, Bruce Momjian wrote: >>> Robert Haas wrote: 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, w

Re: [DOCS] Discrepancy in 9.1 Documentation on CREATE ROLE

2011-10-11 Thread Bruce Momjian
Robert Haas wrote: > On Tue, Oct 11, 2011 at 10:44 AM, Bruce Momjian wrote: > > Robert Haas wrote: > >> On Thu, Oct 6, 2011 at 10:48 PM, Ron Adams > >> wrote: > >> > The help for LOGIN/NOLOGIN at > >> > http://www.postgresql.org/docs/9.1/static/sql-createrole.html: > >> > "...NOLOGIN > >> > is

Re: [DOCS] Discrepancy in 9.1 Documentation on CREATE ROLE

2011-10-11 Thread Robert Haas
On Tue, Oct 11, 2011 at 10:44 AM, Bruce Momjian wrote: > Robert Haas wrote: >> On Thu, Oct 6, 2011 at 10:48 PM, Ron Adams >> 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 i

Re: [DOCS] Discrepancy in 9.1 Documentation on CREATE ROLE

2011-10-11 Thread Bruce Momjian
Robert Haas wrote: > On Thu, Oct 6, 2011 at 10:48 PM, Ron Adams > 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 h

Re: [DOCS] Discrepancy in 9.1 Documentation on CREATE ROLE

2011-10-10 Thread Ron Adams
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 wrote: > On Thu, Oct 6, 2011 at 10:48 PM, Ron Adams > wrote: > > The help for LOGIN/NOLOGIN at > > http:

Re: [DOCS] Discrepancy in 9.1 Documentation on CREATE ROLE

2011-10-10 Thread Robert Haas
On Thu, Oct 6, 2011 at 10:48 PM, Ron Adams 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 clau

[DOCS] Discrepancy in 9.1 Documentation on CREATE ROLE

2011-10-06 Thread Ron Adams
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 SUPERU