Thread: lc_messages 8.3.7
Hi, Postgresql 8.2.13 on Windows (it's correct, "Leden" is the Czech translation of "January"): postgres=# SET lc_messages=en;select to_char('2006/01/01'::timestamp, 'TMMonth'); SET to_char --------- January postgres=# SET lc_messages=cs;select to_char('2006/01/01'::timestamp, 'TMMonth'); SET to_char --------- Leden Postgresql 8.3.7 on Windows (wrong): postgres=# SET lc_messages=en;select to_char('2006/01/01'::timestamp, 'TMMonth'); SET to_char --------- January postgres=# SET lc_messages=cs;select to_char('2006/01/01'::timestamp, 'TMMonth'); SET to_char --------- January Do you have any idea what happens in 8.3.7? Thank you. Pribram
pribram pribram wrote: > postgres=# SET lc_messages=cs;select to_char('2006/01/01'::timestamp, 'TMMonth'); > SET > to_char > --------- > January Hmm, it works fine for me (not Windows though): alvherre=# SET lc_messages='C';select to_char('2006/01/01'::timestamp, 'TMMonth'); SET to_char --------- January (1 fila) alvherre=# SET lc_messages='fr_CA';select to_char('2006/01/01'::timestamp, 'TMMonth'); SET to_char --------- Janvier (1 fila) alvherre=# RESET lc_messages; select to_char('2006/01/01'::timestamp, 'TMMonth'); RESET to_char --------- Enero (1 fila) alvherre=# select version(); version ------------------------------------------------------------------------------------------ PostgreSQL 8.3.7 on x86_64-unknown-linux-gnu, compiled by GCC gcc (Debian 4.3.3-3) 4.3.3 (1 fila) -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc.
Hi Alvaro, thanks for testing. Your SQL commands don't work for me: postgres=# SET lc_messages='C';select to_char('2006/01/01'::timestamp, 'TMMonth'); SET to_char --------- January (1 °ßdka) postgres=# SET lc_messages='fr_CA';select to_char('2006/01/01'::timestamp, 'TMMonth'); SET to_char --------- January (1 °ßdka) postgres=# RESET lc_messages; select to_char('2006/01/01'::timestamp, 'TMMonth'); RESET to_char --------- January (1 °ßdka) postgres=# select version(); version ----------------------------------------------------- PostgreSQL 8.3.7, compiled by Visual C++ build 1400 (1 °ßdka) > ------------ Původní zpráva ------------ > Od: Alvaro Herrera <alvherre@commandprompt.com> > Předmět: Re: [GENERAL] lc_messages 8.3.7 > Datum: 03.6.2009 19:27:38 > ---------------------------------------- > pribram pribram wrote: > > > postgres=# SET lc_messages=cs;select to_char('2006/01/01'::timestamp, > 'TMMonth'); > > SET > > to_char > > --------- > > January > > Hmm, it works fine for me (not Windows though): > > alvherre=# SET lc_messages='C';select to_char('2006/01/01'::timestamp, > 'TMMonth'); > SET > to_char > --------- > January > (1 fila) > > alvherre=# SET lc_messages='fr_CA';select to_char('2006/01/01'::timestamp, > 'TMMonth'); > SET > to_char > --------- > Janvier > (1 fila) > > alvherre=# RESET lc_messages; select to_char('2006/01/01'::timestamp, > 'TMMonth'); > RESET > to_char > --------- > Enero > (1 fila) > > > alvherre=# select version(); > version > > ------------------------------------------------------------------------------------------ > PostgreSQL 8.3.7 on x86_64-unknown-linux-gnu, compiled by GCC gcc (Debian > 4.3.3-3) 4.3.3 > (1 fila) > > -- > Alvaro Herrera http://www.CommandPrompt.com/ > The PostgreSQL Company - Command Prompt, Inc. > > >
Alvaro Herrera wrote: >Hmm, it works fine for me (not Windows though): The lc_messages setting is broken in 8.3 under Windows (not sure whether this will be fixed in 8.4): <http://archives.postgresql.org/pgsql-bugs/2008-11/msg00117.php> Rainer