Re: Case sensitive order by

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
>