Regex select ~ with ^ not using index on char field or text; Locale bug? - Mailing list pgsql-general

From Greg Maxwell
Subject Regex select ~ with ^ not using index on char field or text; Locale bug?
Date
Msg-id Pine.GSO.3.96.1010427141819.19462H-100000@da1server
Whole thread Raw
Responses Re: Regex select ~ with ^ not using index on char field or text; Locale bug?
List pgsql-general
Just migrated a database from a RH6.1 + PG 7.0.3 system to a RH7.1 + PG
7.1 (rpms from ftp.postgresql.org (postgresql-server-7.1-1)).

On performing queries such as select * from table where name ~ '^NAME.*';
the database fails to use the available Btree index where available, even
when the database is told not to use the SEQ_SCAN optimization.

Figured it was a locale related bug..

PGsql was initlized and is started with the scripts in the RPM, so
LC_ALL=C is set.  PSQL is also run with LC_ALL=C.

Am I going to need to hack the .spec to remove --enable-locale and
recompile?

--
The comments and opinions expressed herein are those of the author of this
message and may not reflect the policies of the Martin County Board of
County Commissioners.


pgsql-general by date:

Previous
From: "mike"
Date:
Subject: Pgsql radius authntication
Next
From: Feite Brekeveld
Date:
Subject: FATAL 2 : after a vacuum, can't start postmaster anymore