Re: Indexed leading substring searches - worked, now doesn't - Mailing list pgsql-general

From Tom Lane
Subject Re: Indexed leading substring searches - worked, now doesn't
Date
Msg-id 3156.1107462593@sss.pgh.pa.us
Whole thread Raw
In response to Indexed leading substring searches - worked, now doesn't  (Wes <wespvp@syntegra.com>)
Responses Re: Indexed leading substring searches - worked, now  (Wes <wespvp@syntegra.com>)
List pgsql-general
Wes <wespvp@syntegra.com> writes:
> The locale is showing up as en_US.iso885915.  As far as I know, it was
> always this (default RedHat install), so I don't understand why it worked
> before.  Did something change between 7.4.1 and 7.4.5?  I supposed it's
> possible that I specified locale=C on the original database and don't
> remember that...

You got it in one ...

> I'm not going to have to "initdb --locale=C" and am I?

You could use the alternative operator classes for pattern searches, but
if you want the same indexes to also serve for normal text sorting,
C locale is the better bet.

            regards, tom lane

pgsql-general by date:

Previous
From: "Oisin Glynn"
Date:
Subject: Re: Select from function for part of column results
Next
From: Karl Denninger
Date:
Subject: Eeek! Major problem after reload with tsearch2