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.