Approved

Please see the attached file.
>From pgsql-hackers-owner(at)postgresql(dot)org Sat Jun 7 03:48:14 2003
X-Original-To: pgsql-hackers-postgresql(dot)org(at)localhost(dot)postgresql(dot)org
Received: from localhost (developer.postgresql.org [64.117.224.193])
by svr1.postgresql.org (Postfix) with ESMTP id E2238F0003
for <pgsql-hackers-postgresql(dot)org(at)localhost(dot)postgresql(dot)org>; Sat, 7 Jun 2003 01:24:03 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new, port 10024)
with ESMTP id 46669-02
for <pgsql-hackers-postgresql(dot)org(at)localhost(dot)postgresql(dot)org>;
Sat, 7 Jun 2003 01:24:02 +0000 (GMT)
Received: from candle.pha.pa.us (momjian.navpoint.com [207.106.42.251])
by svr1.postgresql.org (Postfix) with ESMTP id 8B7CFEFFD5
for <pgsql-hackers(at)postgresql(dot)org>; Sat, 7 Jun 2003 01:24:01 +0000 (GMT)
Received: (from pgman(at)localhost)
by candle.pha.pa.us (8.11.6/8.11.6) id h571NUs05903;
Fri, 6 Jun 2003 21:23:30 -0400 (EDT)
From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Message-Id: <200306070123(dot)h571NUs05903(at)candle(dot)pha(dot)pa(dot)us>
Subject: Re: default locale considered harmful? (was Re: [GENERAL]
In-Reply-To: <Pine(dot)LNX(dot)4(dot)33(dot)0306060859080(dot)19717-100000(at)css120(dot)ihs(dot)com>
To: "scott.marlowe" <scott(dot)marlowe(at)ihs(dot)com>
Date: Fri, 6 Jun 2003 21:23:30 -0400 (EDT)
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>,
PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
X-Mailer: ELM [version 2.4ME+ PL99 (25)]
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset=US-ASCII
X-Archive-Number: 200306/112
X-Sequence-Number: 39419

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(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