Re: order by differences: locale problem?

Raphael Bauduin <rblists@gmail.com> writes:
> I have ordering differences between 2 servers, running both the same
> linux distribution (debian), the same postgresql server (8.2.9, though
> one was compiled, and the order installed with debian packages).
> Both have differences in ordering, and I don't know which settings
> influence this behaviour:

lc_collate and lc_ctype.  Unfortunately the only way to change these
is to re-initdb.  (See the --locale switch to initdb.)

            regards, tom lane