lc_messages 8.3.7

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)

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&gt;

Rainer