=?ISO-8859-1?Q?Kristian_J=F6rg?= <[EMAIL PROTECTED]> writes:
> Unfortunately this does not seem to help! I dumped the database,
> recreated the cluster with initdb with LC_COLLATE = C (and even tried
> setting LC_CTYPE to C also), and restored the database. The same
> ordering appears...
You didn't do it right then ...
7.2's initdb is not helpful about telling you exactly what locale
settings it's using, but you could use the contrib/pg_controldata
utility to check what LC_COLLATE and LC_CTYPE settings got used.
(If you don't want to build pg_controldata, "strings
$PGDATA/global/pg_control" will do as a rough-and-ready substitute.)
Theoretically it should work to do
export LC_COLLATE=C
export LC_CTYPE=C
initdb
but if you have LANG or other LC_xxx values in your environment,
it's possible that there is some conflict.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
