From: | Oleg Bartunov <oleg(at)sai(dot)msu(dot)su> |
---|---|
To: | pgsql-hackers(at)postgreSQL(dot)org |
Subject: | a little addition to INSTALL |
Date: | 1998-10-26 08:20:39 |
Message-ID: | Pine.GSO.3.96.SK.981026110219.827A-100000@ra |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi,
I think we need to add this to INSTALL file after setting
environmnet variable TZ.
'If you compile Postgres with --enable-locale option
set locale environment to C (or unset all LC_* variables)
before starting postmaster.'
Several regression tests could failed if user's locale collation
scheme is different from that of standard C locale.
For example select_implicit and select_having failed on my
Linux machine when I start postmaster and use koi8-r locale
and passed fine if I unset all locale variables.
I don't know why collation scheme of my locale affects to english
characters ? but this could be a source of confusion for people.
results/select_implicit.out:
c |count
--------+-----
AAAA | 2
BBBB | 2
bbbb | 1 ?????
CCCC | 2
cccc | 2
XXXX | 1
expected/select_implicit.out:
c |count
--------+-----
AAAA | 2
BBBB | 2
CCCC | 2
XXXX | 1
bbbb | 1
cccc | 2
I think my locale is broken in this respect.
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83
From | Date | Subject | |
---|---|---|---|
Next Message | Jan Wieck | 1998-10-26 08:29:41 | Re: [HACKERS] Features list |
Previous Message | Jan Wieck | 1998-10-26 08:14:15 | Re: [HACKERS] pg_indexes |