Tom Lane <tgl@sss.pgh.pa.us> writes:
> BTW: one thing to beware of when using LOCALE is that you've gotta be
> careful to start the postmaster with the same LOCALE environment
> variables every time for a given database. Otherwise, the
> LOCALE-dependent sort order of your indexes gets messed up, and things
> start to behave very strangely ...
>
And you have to reindex the relevant tables to get things working properly
again. I did this two months ago to get the right sort order for norwegian
letters(ISO-8859-1 character encoding).
Works like I a charm now on Solaris, but I still have a problem on my Linux
development machine - believe this a Linux libc config problem and not
related to Postgres as it works fine on Solaris.
regards,
Gunnar