Approved

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