jcrada wrote:
Hi, I'm having trouble displaying date names in other locales:central=# show lc_messages; lc_messages ----------------- fr_FR.ISO8859-1 (1 row) central=# select to_char('2007/01/01'::date,'TMMonth'); to_char --------- January (1 row) This result is not the expected result, since my locale is fr_FR I expect (as older versions of psql) to return Janvier instead. The same applies when lc_messages = 'es_VE'. Localization support in dates using to_char(date,varchar) is gone.
Most likely, you're using a version compiled without Native Language Support support (see --enable-nls configure option).
-- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com -- Sent via pgsql-bugs mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
