Many thanks guys !!
Everyone who suggested cause of problem due to LC_COLLATE setting C was
correct.
Problem is resolved.
Apologies for the multiple post.
Kind regards,
JE
-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of John R Pierce
Sent: Monday, August 01, 2011 10:58 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] string comparison problem
On 08/01/11 11:12 AM, Johnny Edge wrote:
> I have a problem with identical versions of postgresql - 8.3.13 Config
> files are identical. HostA is a 32 bit CentOS 5.3 install and the
> hostB is x86_64 CentOS 6.
> Difference in architecture should not be a problem - I have another 64
> bit CentOS where both queries are executed displaying identical
results.
> However, libraries which postgresql is compiled against on host B are
> significantly newer.
> Any thoughts how can this be resolved?
> PostgreSQL is compiled from source on both servers.
same client encoding on both instances?
SHOW CLIENT_ENCODING;
SHOW LC_COLLATE;
--
john r pierce N 37, W 122
santa cruz ca mid-left coast
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To
make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general