Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id D8C461C7037D for ; Tue, 13 Dec 2011 19:36:42 -0400 (AST) Received: from momjian.us ([72.94.173.45]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Rabtp-0007gE-DF for pgsql-docs@postgresql.org; Tue, 13 Dec 2011 23:36:43 +0000 Received: (from bruce@localhost) by momjian.us (8.11.6/8.11.6) id pBDNaRB21797; Tue, 13 Dec 2011 18:36:27 -0500 (EST) From: Bruce Momjian Message-Id: <201112132336.pBDNaRB21797@momjian.us> Subject: Re: CREATE USER In-Reply-To: <9796.1323487277@sss.pgh.pa.us> To: Tom Lane Date: Tue, 13 Dec 2011 18:36:27 -0500 (EST) CC: Jaime Casanova , pgsql-docs X-Mailer: ELM [version 2.4ME+ PL124 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset="US-ASCII" X-Pg-Spam-Score: -4.2 (----) X-Archive-Number: 201112/35 X-Sequence-Number: 7142 Tom Lane wrote: > Jaime Casanova writes: > > I just notice that when you create a user using CREATE USER and give > > the user the ability to create other users it gets created as > > SUPERUSER. > > Are you talking about the CREATEUSER option? That is documented, quite > clearly I think: > > CREATEUSER > NOCREATEUSER > > 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! > > The only way we could really make this any better is to remove these > keywords, which might be something to consider. The preferred SUPERUSER > spelling has been accepted since 8.1 ... is that long enough to ensure > everyone's converted their client-side tools? Probably not :-( How does this relate to people restoring pre-8.1 pg_dumpall dumps? Seems removing this option would cause the restore to fail. -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. +