| From: | Michaël Fiey <m(dot)fiey(at)futuresoundtech(dot)com> |
|---|---|
| To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Case sensitive order by |
| Date: | 2001-05-09 15:36:53 |
| Message-ID: | 000601c0d89d$df94a620$6400a8c0@pc03 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
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(at)sss(dot)pgh(dot)pa(dot)us>
To: Michaël Fiey <m(dot)fiey(at)futuresoundtech(dot)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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-05-09 15:45:08 | Re: Case sensitive order by |
| Previous Message | Mark R | 2001-05-09 15:34:59 | Newbie HOWTO |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-05-09 15:38:39 | Coping with huge deferred-trigger lists |
| Previous Message | Kovacs Zoltan | 2001-05-09 15:23:34 | I still cannot force pg_dump to disable triggers |