From: | Manuel Sugawara <masm(at)fciencias(dot)unam(dot)mx> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | problems with locale settings |
Date: | 2005-02-19 06:21:35 |
Message-ID: | m3wtt5vzm8.fsf@conexa.fciencias.unam.mx |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Hallgren | 2005-02-19 10:07:51 | Re: SPI_finish and RegisterExprContextCallback |
Previous Message | Tom Lane | 2005-02-19 05:57:52 | Re: 8.0.X and the ARC patent |