Обсуждение: lc_messages 8.3.7

Поиск
Список
Период
Сортировка

lc_messages 8.3.7

От
pribram pribram
Дата:
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

Re: lc_messages 8.3.7

От
Alvaro Herrera
Дата:
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.

Re: [GENERAL] lc_messages 8.3.7

От
pribram pribram
Дата:
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.
>
>
>

Re: lc_messages 8.3.7

От
Rainer Bauer
Дата:
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