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.
>
>
>