From: | "Robert Wille" <vmg2rad02(at)sneakemail(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | LC_COLLATE=C not working |
Date: | 2003-10-03 08:22:00 |
Message-ID: | 397101c38987$6c291d90$6402a8c0@zucchini |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I have two Linux servers, one is test and one is production. I run Postgres 7.3.3 on both of them. I added a feature to my product that requires sorting like strcmp. So, I did an initdb as follows:
export LC_COLLATE=C
initdb
It fixed the sorting problem.
I have tried to do the same on my production server, and when I do the initdb, it says that LC_COLLATE is C, but it does not sort the same as the test server. Namely, on the test server 'z' < '~' and on the production server 'z' > '~'.
Both servers have /usr/share/locale/C/cups_C, and they are identical.
Can anyone explain to me how to get Postgres to use LC_COLLATE=C on my production server? I have tried installing Postgres 7.3.3 RPM's for RedHat 7.3 and 8.0 and even tried Postgres 7.3.4 (for 8.0). Everything sorts the same as en_US.iso885915.
Thanks in advance.
Robert
From | Date | Subject | |
---|---|---|---|
Next Message | Shridhar Daithankar | 2003-10-03 08:30:11 | Re: pg_restore takes ages |
Previous Message | Richard Huxton | 2003-10-03 07:33:30 | Re: Type of application that use PostgreSQL |