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

From Bruce Momjian
Subject Re: default locale considered harmful? (was Re: [GENERAL]
Date
Msg-id 200306070123.h571NUs05903@candle.pha.pa.us
Whole thread Raw
In response to Re: default locale considered harmful? (was Re: [GENERAL]  ("scott.marlowe" <scott.marlowe@ihs.com>)
Responses Re: default locale considered harmful? (was Re: [GENERAL]  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-hackers
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
 


pgsql-hackers by date:

Previous
From:
Date:
Subject: Approved
Next
From: Robert Treat
Date:
Subject: Re: Proposal to Re-Order Postgresql.Conf, part II