Re: default locale considered harmful? (was Re: [GENERAL]

scott.marlowe wrote:
> On Fri, 6 Jun 2003, Peter Eisentraut wrote:
> 
> > scott.marlowe writes:
> > 
> > > If indexes on text worked right in other locales it would be no big deal.
> > 
> > They will in version 7.4, so all these concerns about trading off locale
> > use vs. performance will become obsolete.
> 
> Oh!  I thought there were still issues that couldn't be worked out on that 
> front.  In that case, heck yeah, set the locale on initdb to the current 
> system locale.  sweet.

The problems go away _if_ the user knows about the new way of indexing
LIKE on non-C locales.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073