Alex Krohn <alex(at)gossamer-threads(dot)com> writes:
> [postgres(at)penguin pgsql]$ locale
> [postgres(at)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
In response to
pgsql-bugs by date
|Next:||From: Alex Krohn||Date: 2001-01-26 16:46:40|
|Subject: Re: select fails on indexed varchars.|
|Previous:||From: Peter T Mount||Date: 2001-01-26 09:33:00|
|Subject: Re: [JDBC] Re: JDBC buggy in 7.1beta3|