Re: [BUGS] select fails on indexed varchars.

[Tom Lane]

Alex Krohn <[EMAIL PROTECTED]> writes:
> [postgres@penguin pgsql]$ locale
> LANG=en_US
> LC_CTYPE="en_US"
> LC_NUMERIC="en_US"
> LC_TIME="en_US"
> LC_COLLATE="en_US"
> LC_MONETARY="en_US"
> LC_MESSAGES="en_US"
> LC_ALL=en_US
> [postgres@penguin pgsql]$

> Postmaster is running as user pgsql. Any ideas on workarounds? 

Use locale "C" unless you have a really good reason why you need
en_US sorting order.

Beware of changing the postmaster's locale on the fly, however,
since that will leave you with corrupted (out-of-order) indexes.
Safest to dump/initdb in new locale/reload.

                        regards, tom lane