Wes <wespvp@xxxxxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
