Thread: furiously yours

Hello again,

I've been playing around with different versions of postgresql, I noticed t=
hat if I install the rpms of postgresql7.1 the sorting order become the way=
 I want it. other versions including 7.1.1 and 7.1.2 are similar to version=
 7.0.3 where the sorting is different then 7.1.=20
Correct me if I'm wrong, but it is my understanding that 7.1 rpms where com=
piled on a machine with LC_ALL=3DC and this is why it does the sorting diff=
erently, now for me to be able to have a newer version that sorts things th=
ey way I want them I have to install the srpms and configure, then install =
on my machine, I tried it with a couple of versions and it worked. I also t=
ried to change the LC_ALL variable before runing initdb on the version 7.0.=
3 I have it did not work.
my question is the following: is it customary to have this kind of problems=
 with rpms built on different machines?!? Is it better to always install th=
e srpms to be able to keep consistency?!? It is a bit anoying to do install=
ation from srpms, because you will have to change the paths and startup opt=
ions on the machine manually, but I can not see any other way?!?

thanks,
Rony.

rkrk@hotmail.com writes:

> Correct me if I'm wrong, but it is my understanding that 7.1 rpms where compiled on a machine with LC_ALL=C and this
iswhy it does the sorting differently, now for me to be able to have a newer version that sorts things they way I want
themI have to install the srpms and configure, then install on my machine, I tried it with a couple of versions and it
worked.I also tried to change the LC_ALL variable before runing initdb on the version 7.0.3 I have it did not work. 

It doesn't matter where they were compiled, only what the setting was when
initdb ran.  The rpms set LC_ALL to C somewhere in the environment of the
postgres user or in the init script, I don't remember.  Check there if you
want to change it.

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter