Re: [BUGS] Repeatedly breaking indexes - SOLVED

2003-12-02 Thread Martin Edlman
> "ps" is not a reliable guide to the locale settings being used by > Postgres. Maybe it's RedHat related, I don't know. When I had en_US in /etc/sysconfig/i18n and cs_CZ in ~postgres/.bash_profile and when I did (as root) `su - postgres -s /bin/sh -c "echo $LANG"' I saw LANG=en_US (!!!), when I

Re: [BUGS] Repeatedly breaking indexes - SOLVED

2003-12-01 Thread Tom Lane
Martin Edlman <[EMAIL PROTECTED]> writes: > finally the problem is solved. The problem was with locales. > I installed and initialised the database under cs_CZ, so Pg > recorded cs_CZ in all its configurations and startup scripts. > After that I changed /etc/sysconfig/i18n to us

Re: [BUGS] Repeatedly breaking indexes - SOLVED

2003-11-30 Thread Martin Edlman
Hello, finally the problem is solved. The problem was with locales. I installed and initialised the database under cs_CZ, so Pg recorded cs_CZ in all its configurations and startup scripts. After that I changed /etc/sysconfig/i18n to use en_US locale as system default.