a little addition to INSTALL

Started by Oleg Bartunovabout 27 years ago2 messages
#1Oleg Bartunov
oleg@sai.msu.su

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@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

#2Thomas G. Lockhart
lockhart@alumni.caltech.edu
In reply to: Oleg Bartunov (#1)
Re: [HACKERS] a little addition to INSTALL (fwd)

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.'

Hi Oleg. We are rewriting the installation instructions, and I have
included your full description of locale support into those
instructions. I had not added in an explicit mention into the
installation procedure also, but will do that.

- Tom