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 200306100453.h5A4rX209014@candle.pha.pa.us
Whole thread Raw
In response to 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, Bruce Momjian wrote:
> 
> > 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.
> 
> Should we have something about this mentioned in 
> 
> http://developer.postgresql.org/docs/postgres/install-upgrading.html
> 
> for the 7.4 release?  Or is there a more appropriate place?

Yes, at a minimum, plus we need someone coming fresh to 7.5 to know this
is an issue.

--  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: Bruce Momjian
Date:
Subject: Re: Proposal to Re-Order Postgresql.Conf, part II
Next
From: "J.R. Nield"
Date:
Subject: Returning to the List