Re: per-database locale: createdb switches

Heikki Linnakangas wrote:
> Peter Eisentraut wrote:

>> I notice in the documentation that the createdb --lc-ctype sets the  
>> lc_ctype setting for the database, but the corresponding parameter for  
>> CREATE DATABASE is CTYPE, but the global GUC setting is lc_ctype. 
>> Should that be more consistent?
>
> Hmm, I remember I pondered for a long time if it should be COLLATE and  
> CTYPE or LC_COLLATE and LC_CTYPE. I think the rationale in the end was  
> that a) COLLATE/CTYPE looks nicer and b) if we add support for ICU or  
> some other collation implementation, the association with LC_*  
> environment variables becomes misleading.
>
> Being consistent would be nice, though.

I think consistency could be reached by renaming the GUC setting to
ctype.  We could add a "lc_ctype" synonym for backwards compatibility
(like sort_mem) -- or maybe not.

Since the createdb setting is new as of 8.4, we should just rename that
to ctype as well.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.