Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id E5111B5DBF4 for ; Tue, 11 Oct 2011 12:59:18 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 83662-05 for ; Tue, 11 Oct 2011 15:59:12 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.8.0-rc2 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by mail.postgresql.org (Postfix) with ESMTP id BC37CB5DBD9 for ; Tue, 11 Oct 2011 12:59:12 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id p9BFxAI9001735; Tue, 11 Oct 2011 11:59:10 -0400 (EDT) To: Bruce Momjian cc: Robert Haas , Ron Adams , pgsql-docs@postgresql.org Subject: Re: Discrepancy in 9.1 Documentation on CREATE ROLE In-reply-to: <201110111511.p9BFBYX17467@momjian.us> References: <201110111511.p9BFBYX17467@momjian.us> Comments: In-reply-to Bruce Momjian message dated "Tue, 11 Oct 2011 11:11:34 -0400" Date: Tue, 11 Oct 2011 11:59:10 -0400 Message-ID: <1734.1318348750@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.404 tagged_above=-5 required=5 tests=BAYES_00=-1.9, RP_MATCHES_RCVD=-0.504 X-Spam-Level: X-Archive-Number: 201110/25 X-Sequence-Number: 7025 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, 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. 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 newer pg_dump. regards, tom lane