Re: per-database locale: createdb switches

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>, Teodor Sigaev <teodor(at)sigaev(dot)ru>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: per-database locale: createdb switches
Date: 2009-02-13 09:27:01
Message-ID: 49953CE5.4020609@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Bruce Momjian wrote:
> Tom Lane wrote:
>> Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
>>> Heikki Linnakangas wrote:
>>>> 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.
>> I think this is a bad idea, particularly if you also rename the other
>> GUC to COLLATE (which is a reserved word that we're going to have to
>> implement someday). People know what LC_CTYPE and LC_COLLATE do,
>> at least if they've heard of Unix locale support at all (and if not
>> they can google those names successfully).
>>
>> If we want consistency then the right answer is to rename the *new*
>> things to lc_xxx, not break compatibility on the names of the
>> existing things.
>
> Is anyone working on resolving this?

I think we can just leave it for now.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2009-02-13 09:38:54 Re: WIP: hooking parser
Previous Message John Lister 2009-02-13 09:17:39 Re: Database corruption help