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