problems with locale settings
Started by Manuel Sugawaraalmost 21 years ago1 messages
Hi,
Starting postgres as part as of the normal boot process of my db
server (up2date FC3) leads to an ``unusable'' database since it does
not set the locale properly. For instnace:
test=# select 'í' ~ '[[:lower:]]';
?column?
----------
f
(1 fila)
However, starting postgres as
$ LANG=es_MX pg_ctl -D ~/data start
leads the desired result:
test=# select 'í' ~ '[[:lower:]]';
?column?
----------
t
(1 fila)
There's something wired here since my (fast) reading of the sources
makes me thing that postgres should honor the pg_control's lc_type
locale settings. BTW, I couldn't reproduce this in another machine
using pg 8.0.1.
Regards,
Manuel.