Please see the attached file.
>From pgsql-hackers-owner@postgresql.org  Sat Jun  7 03:48:14 2003
X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org
Received: from localhost (developer.postgresql.org [64.117.224.193])
	by svr1.postgresql.org (Postfix) with ESMTP id E2238F0003
	for <pgsql-hackers-postgresql.org@localhost.postgresql.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.org@localhost.postgresql.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@postgresql.org>; Sat,  7 Jun 2003 01:24:01 +0000 (GMT)
Received: (from pgman@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@candle.pha.pa.us>
Message-Id: <200306070123.h571NUs05903@candle.pha.pa.us>
Subject: Re: default locale considered harmful? (was Re: [GENERAL]
In-Reply-To: <Pine.LNX.4.33.0306060859080.19717-100000@css120.ihs.com>
To: "scott.marlowe" <scott.marlowe@ihs.com>
Date: Fri, 6 Jun 2003 21:23:30 -0400 (EDT)
Cc: Peter Eisentraut <peter_e@gmx.net>,
	PostgreSQL Development <pgsql-hackers@postgresql.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@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

Fri, 6 Jun 2003 21:39:20 --0400
<tih@kpnQwest.no>
Approved