Message-ID: <4DD62FE1.9010607@2ndQuadrant.com>
Date: Fri, 20 May 2011 11:09:53 +0200
From: Susanne Ebrecht <susanne@2ndQuadrant.com>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US;
	rv:1.9.2.17) Gecko/20110424 Thunderbird/3.1.10
MIME-Version: 1.0
To: Robert Haas <robertmhaas@gmail.com>
CC: Grzegorz Szpetkowski <gszpetkowski@gmail.com>, pgsql-docs@postgresql.org
Subject: Re: createuser/dropuser username
References: <BANLkTik=8Mi4L9n=8=P0ez4Xen4YuGX8vw@mail.gmail.com>
	<BANLkTinBHVbx+Wqp9vAGLkW7LyEm5iK_0w@mail.gmail.com>
In-Reply-To: <BANLkTinBHVbx+Wqp9vAGLkW7LyEm5iK_0w@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

On 19.05.2011 22:15, Robert Haas wrote:
> On Wed, May 4, 2011 at 12:05 PM, Grzegorz Szpetkowski
> <gszpetkowski@gmail.com>  wrote:
>> Hi,
>>
>> I think that createuser/drouser reference documentation could be
>> enhanced for username param. There is:
>>
>> "createuser is a wrapper around the SQL command CREATE ROLE. There is
>> no effective difference between creating users via this utility and
>> via other methods for accessing the server."
>>
>> http://www.postgresql.org/docs/9.0/static/app-createuser.html
>> http://www.postgresql.org/docs/9.0/static/app-dropuser.html
>>
>> But createuser and dropuser wrappers in some cases are doing implicit
>> quoting (when CREATE ROLE is not), which I think is not fully known
>> and is undocumented here. For example:
> I'm not sure this really needs to be documented, but what exactly do
> you have in mind?

Honestly, I think we should document that the scripts use quotes.
I just made an ad-hoc look into the docs and couldn't find something 
about it.

Lots of years ago - you could see me sitting in front of my computer and
wondering - because I used:
$ createdb test
$ createdb tEst
I wondered that I didn't got an error message.

Thinking deeper about it just let it get logical to me that createdb 
quotes by
automatism.

But this isn't logical on the first view - because we point out that all 
will get
to lower case without quotes.

PostgreSQL even is so intelligent - that when you say:
$ createdb "tEst" - it will ignore the quotes - you will get database 
named tEst and not
named "tEst".

This all isn't really obvious to a typical user.

Best Regards,

Susanne

-- 
Susanne Ebrecht - 2ndQuadrant
PostgreSQL Development, 24x7 Support, Training and Services
www.2ndQuadrant.com