From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Andrew Sullivan <andrew(at)libertyrms(dot)info> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org>, pgsql-hackers(at)postgresql(dot)org |
Subject: | default locale considered harmful? (was Re: Using index for "like 'ABC%'" type query) |
Date: | 2003-04-18 14:48:21 |
Message-ID: | 3954.1050677301@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
Andrew Sullivan <andrew(at)libertyrms(dot)info> writes:
>> [ can't LIKE use an index? ]
> Yes. But locale is enabled by default now, and if you use anything
> other than C (and other-than-C is increasingly the default on the
> supported platforms), it won't work. Just make sure that your locale
> is C when you do initdb.
I recall someone floating a proposal that initdb should by default
initialize the database in C locale, not whatever-it-finds-in-the-
environment. To get a non-C locale you'd have to give an explicit
command-line switch --- essentially, reversing the sense of the present
"initdb --no-locale" option.
I'm beginning to think that would be a good idea, given the increasing
prevalence of en_US as a platform locale setting. Comments?
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2003-04-18 15:07:15 | Re: [HACKERS] default locale considered harmful? (was Re: |
Previous Message | Tom Lane | 2003-04-18 14:40:44 | Re: Weird "template1" errors on CREATE DATABASE |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-04-18 14:51:39 | Re: [PERFORM] Foreign key performance |
Previous Message | Stephan Szabo | 2003-04-18 14:47:15 | Re: [PERFORM] Foreign key performance |