BUG #4454: LC_MESSAGES and LC_NUMERIC not working on Windows

The following bug has been logged online:

Bug reference: 4454
Logged by: Rainer Bauer
Email address: usenet(at)munnin(dot)com
PostgreSQL version: 8.3.4
Operating system: WinXPSP3
Description: LC_MESSAGES and LC_NUMERIC not working on Windows
Details:

Hello,

This is an _ENGLISH_ Windows XPSP3 installation where the "Regional and
Language Options" have been set to "German (Germany)". The cluster was
initialized with locale "German_Germany".

The first problem is that I cannot change the messages returned from the
backend to English. Setting LC_MESSAGES has no effect. Renaming the
"~\share\locale\de" folder in the program installation was suggested here
<http://archives.postgresql.org/pgsql-general/2008-09/msg00805.php>. It
works, but this does not solve the problem that I consider to be a bug.

The next problem I am facing is that float data sent to the backend is not
accepted, because the comma separator is used in the program and the backend
expects a point separator.

I have read <http://www.postgresql.org/docs/8.3/static/locale.html> and
<http://www.postgresql.org/docs/8.3/static/functions-formatting.html>. But
setting LC_NUMERIC has no effect: it always returns "1.3" instead of "1,3"
(see ouput from a psql console below).

So either I am doing something completely wrong or this is a bug.

Regards,

Rainer

Welcome to psql 8.3.4, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit

Warning: Console code page (850) differs from Windows code page (1252)
8-bit characters might not work correctly. See psql reference
page "Notes for Windows users" for details.

postgres=# select version();
version
-----------------------------------------------------
PostgreSQL 8.3.4, compiled by Visual C++ build 1400
(1 row)

postgres=# SHOW LC_MESSAGES;
lc_messages
----------------
German_Germany
(1 row)

postgres=# SHOW LC_MONETARY;
lc_monetary
----------------
German_Germany
(1 row)

postgres=# SHOW LC_TIME;
lc_time
----------------
German_Germany
(1 row)

postgres=# SHOW LC_NUMERIC;
lc_numeric
----------------
German_Germany
(1 row)

postgres=# select 1.3::float;
float8
--------
1.3
(1 row)

postgres=# SET LC_NUMERIC TO ''; select 1.3::float;
SET
float8
--------
1.3
(1 row)

postgres=# SET LC_NUMERIC TO 'C'; select 1.3::float;
SET
float8
--------
1.3
(1 row)

postgres=# SET LC_NUMERIC TO 'German_Germany'; select 1.3::float;
SET
float8
--------
1.3
(1 row)

postgres=# SET LC_NUMERIC TO 'German_Germany.1252'; select 1.3::float;
SET
float8
--------
1.3
(1 row)

postgres=#

I wrote:

>I have read <http://www.postgresql.org/docs/8.3/static/locale.html> and
><http://www.postgresql.org/docs/8.3/static/functions-formatting.html>. But
>setting LC_NUMERIC has no effect: it always returns "1.3" instead of "1,3"
>(see ouput from a psql console below).

Anybody?

Rainer