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. ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings