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

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
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-10 04:53:33
Message-ID: 200306100453.h5A4rX209014@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Larry Rosenman 2003-06-10 07:08:02 Re: 7.3.3 COMPILE FAILURE: pg_dump (fwd)
Previous Message Bruce Momjian 2003-06-10 04:51:49 Re: Proposal to Re-Order Postgresql.Conf, part II