You're right !
LC_ALL=C explain the difference.
But I haven't found pg_controldata on my platform.
Is it installed with Postgresql 7.1 RPM for Redhat 7.0 ?
Thank's for your help
regards
----- Original Message -----
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Michaël Fiey <m.fiey@futuresoundtech.com>
Sent: Wednesday, May 09, 2001 4:28 PM
Subject: Re: [GENERAL] Case sensitive order by
> > On my prod platform :
> > aaa
> > bbb
> > ccc
> > AAA
> > BBB
> > CCC
>
> > And on my dev platform :
> > aaa
> > AAA
> > bbb
> > BBB
> > ccc
> > CCC
>
> Are you sure that both databases are running with the same locale
> settings? pg_controldata can tell you for sure.
>
> regards, tom lane
>