Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 9CBD7133798E for ; Mon, 2 May 2011 13:47:46 -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 45841-08 for ; Mon, 2 May 2011 16:47:28 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from spinlock.commandprompt.com (unknown [207.173.203.215]) by mail.postgresql.org (Postfix) with ESMTP id 4F9131337990 for ; Mon, 2 May 2011 13:47:27 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by spinlock.commandprompt.com (Postfix) with ESMTP id 21517348045; Mon, 2 May 2011 09:47:07 -0700 (PDT) X-Virus-Scanned: Debian amavisd-new at commandprompt.com Received: from spinlock.commandprompt.com ([127.0.0.1]) by localhost (spinlock.commandprompt.com.commandprompt.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 6Ifwpt9DhVhl; Mon, 2 May 2011 09:47:05 -0700 (PDT) Received: from perhan.alvh.no-ip.org (unknown [200.85.212.110]) by spinlock.commandprompt.com (Postfix) with ESMTPSA id D5B42348022; Mon, 2 May 2011 09:47:04 -0700 (PDT) Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id 999E26E471; Mon, 2 May 2011 13:47:01 -0300 (CLST) Content-Type: text/plain; charset=UTF-8 Cc: pgsql-docs Subject: Re: Documentation tweaks: ALTER USER, statement-based middleware From: Alvaro Herrera To: Greg Smith In-reply-to: <4DBB8614.70307@2ndQuadrant.com> References: <4DBB8614.70307@2ndQuadrant.com> Date: Mon, 02 May 2011 13:47:01 -0300 Message-Id: <1304354640-sup-6836@alvh.no-ip.org> User-Agent: Sup/git Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.107 tagged_above=-5 required=5 tests=BAYES_00=-1.9, RDNS_NONE=0.793 X-Spam-Level: X-Archive-Number: 201105/2 X-Sequence-Number: 6677 Excerpts from Greg Smith's message of sáb abr 30 00:46:28 -0300 2011: > Two small patches attached, based on recent documentation comments > suggested on the web site. > > First alters a few places that ALTER USER is suggested, mainly in the > context of changing per-user settings. If you're reading the HTML > documentation, and you click on ALTER USER, it takes you to a slim page > that tells you what you really wanted was ALTER ROLE. That's kind of > wasteful, and thus the idea to go directly there. Original doc > suggestion from Grzegorz Szpetkowski, I found a few more places to tweak > when assembling the patch. I applied this bit. I am unsure about the CREATE USER mentions that appear just before each ALTER USER spot that got modified; should those be updated to CREATE ROLE as well? The only difference is that CREATE USER adds the LOGIN privileges automatically, but the CREATE USER as as skinny as ALTER USER. Thoughts? -- Álvaro Herrera The PostgreSQL Company - Command Prompt, Inc. PostgreSQL Replication, Consulting, Custom Development, 24x7 support