Postgres Pro
Downloads
Home   >   mailing lists

Re: order by differences: locale problem? - Mailing list pgsql-novice

From Tom Lane
Subject Re: order by differences: locale problem?
Date
Msg-id 5577.1232031810@sss.pgh.pa.us
Whole thread Raw
In response to order by differences: locale problem?  (Raphael Bauduin <rblists@gmail.com>)
List pgsql-novice
Tree view 
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

pgsql-novice by date:

Previous
From: "Wright, George"
Date:
Subject: Re: function transaction scope question
Next
From: John DeSoi
Date:
Subject: Re: function transaction scope question