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

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>, PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: default locale considered harmful? (was Re: [GENERAL]
Date: 2003-06-09 14:47:26
Message-ID: Pine.LNX.4.33.0306090846450.1952-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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?

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jonathan Gardner 2003-06-09 15:42:25 Re: Some quick notes about extending libpq for new protocol
Previous Message Tom Lane 2003-06-09 14:09:20 Re: freeaddrinfo2 changes.