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 <[EMAIL PROTECTED]>
To: Michaël Fiey <[EMAIL PROTECTED]>
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
>
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
