Re: bug in string comparison

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: kopljan(at)beotel(dot)net
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: bug in string comparison
Date: 2010-02-27 01:33:23
Message-ID: 9613.1267234403@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"kopljan" <kopljan(at)beotel(dot)net> writes:
> Description: bug in string comparison

What this sounds like is you are using two different locale settings
in the 8.2 and 8.4 installations. Postgres' string comparisons follow
whatever the rules of the locale are. Try "show lc_collate" to see
what the setting is.

In 8.2 the locale is determined at initdb time, but in 8.4 you can
set it when creating a database.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Oleg Serov 2010-02-27 14:13:54 Re: Diffrent column ordering after dump/restore tables with INHERITS
Previous Message kopljan 2010-02-27 00:20:24 bug in string comparison