Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 16EAB358181 for ; Fri, 9 Dec 2011 17:09:55 -0400 (AST) Received: from mail-ww0-f50.google.com ([74.125.82.50]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1RZ7ha-0003O8-Dl for pgsql-docs@postgresql.org; Fri, 09 Dec 2011 21:09:55 +0000 Received: by wgbdr11 with SMTP id dr11so6375968wgb.19 for ; Fri, 09 Dec 2011 13:09:41 -0800 (PST) Received: by 10.216.139.79 with SMTP id b57mr493305wej.111.1323464981160; Fri, 09 Dec 2011 13:09:41 -0800 (PST) MIME-Version: 1.0 Received: by 10.180.7.230 with HTTP; Fri, 9 Dec 2011 13:09:25 -0800 (PST) From: Jaime Casanova Date: Fri, 9 Dec 2011 16:09:25 -0500 X-Google-Sender-Auth: 1Ixz1jNWqSLieqEF727VHhjTJaU Message-ID: Subject: CREATE USER To: pgsql-docs Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Pg-Spam-Score: -1.1 (-) X-Archive-Number: 201112/26 X-Sequence-Number: 7133 Hi, 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. CREATE ROLE behaves as expected. Looking at src/backend/parser/gram.y seems it's intentional, for backwards compatibility. But the docs says: """ CREATE USER is now an alias for CREATE ROLE. The only difference is that when the command is spelled CREATE USER, LOGIN is assumed by default, whereas NOLOGIN is assumed when the command is spelled CREATE ROLE. """ So, at least, we need to update docs or is undocumented intentionally too? also i really think the command should raise a WARNING so we now what's happening --=20 Jaime Casanova=A0 =A0 =A0 =A0=A0 www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitaci=F3n