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?


Mon, 9 Jun 2003 08:47:26 -0600 (MDT)
"scott.marlowe" <scott.marlowe@ihs.com>
Re: default locale considered harmful? (was Re: [GENERAL]
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, Pennsylvania 19073

Tue, 10 Jun 2003 00:53:33 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: default locale considered harmful? (was Re: [GENERAL]