X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id A4C693A4B76
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Sun, 14 Nov 2004 00:02:20 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 11343-05
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Sun, 14 Nov 2004 00:02:16 +0000 (GMT)
Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130])
	by svr1.postgresql.org (Postfix) with ESMTP id 8B5633A4B55
	for <pgsql-sql@postgresql.org>; Sun, 14 Nov 2004 00:02:17 +0000 (GMT)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id iAE024VL003973;
	Sat, 13 Nov 2004 19:02:06 -0500 (EST)
To: Stephan Szabo <sszabo@megazone.bigpanda.com>
Cc: carex <carex@skynet.be>, pgsql-sql@postgresql.org
Subject: Re: select using regexp does not use indexscan 
In-reply-to: <20041113133651.A44723@megazone.bigpanda.com> 
References: <3a0a211c.0411091202.223f1c02@posting.google.com>
	<20041113133651.A44723@megazone.bigpanda.com>
Comments: In-reply-to Stephan Szabo <sszabo@megazone.bigpanda.com>
	message dated "Sat, 13 Nov 2004 13:39:27 -0800"
Date: Sat, 13 Nov 2004 19:02:04 -0500
Message-ID: <3972.1100390524@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests=
X-Spam-Level: 
X-Archive-Number: 200411/132
X-Sequence-Number: 19451

Stephan Szabo <sszabo@megazone.bigpanda.com> writes:
> On Tue, 9 Nov 2004, carex wrote:
>> And it works also perfectly with Gentoo.
>> So,is this a typical "Redhat Enterprise" problem ?
>> Or do I overlook something ??

> IIRC, in 7.3.x, index scans are only considered in "C" locale for
> regexp/LIKE. In 7.4.x, non-"C" locale databases can use a special
> index of a different opclass (<typename>_pattern_ops I believe).

Not sure if this answer was explicit enough, so: evidently the database
was initdb'd in "C" locale on Gentoo, but in some other locale on Red Hat.
The only "typical Red Hat problem" is that they are more enthusiastic
about setting up non-C default locales than some other distros.

			regards, tom lane