Re: default locale considered harmful? (was Re: [GENERAL] - Mailing list pgsql-hackers

From Tom Lane
Subject Re: default locale considered harmful? (was Re: [GENERAL]
Date
Msg-id 17973.1054355535@sss.pgh.pa.us
Whole thread Raw
In response to Re: default locale considered harmful? (was Re: [GENERAL]  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: default locale considered harmful? (was Re: [GENERAL]  (Peter Eisentraut <peter_e@gmx.net>)
Re: default locale considered harmful? (was Re: [GENERAL]  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Has the single-byte LIKE penalty been eliminated, so we don't need to
> consider using C as the default locale for initdb, right?

I'm still of the opinion that we should make C the default locale.
But I'm not sure where the consensus is, so I've not made the change.

> If fixed, how was it done?

Peter has provided a hack whereby one can create a LIKE-supporting index
in a non-C locale.  But a *default* index in a non-C locale is still not
going to support LIKE ... and the hacked index will not support ordinary
comparison or ordering operators.  So I think there's still a lot left
to be desired here.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: default locale considered harmful? (was Re: [GENERAL]
Next
From: Mike Mascari
Date:
Subject: A few notes