BUG #4612: lc_numeric setting ignored

LC_NUMERIC only controls formatting functions, not raw input; from the
manual entry on lc_numeric:

Sets the locale to use for formatting numbers, for example
with the <function>to_char</function> family of
functions. Acceptable values are system-dependent; see <xref
linkend="locale"> for more information. If this variable is
set to the empty string (which is the default) then the value
is inherited from the execution environment of the server in a
system-dependent way.

---------------------------------------------------------------------------

Mark Hayen wrote:

The following bug has been logged online:

Bug reference: 4612
Logged by: Mark Hayen
Email address: mark.hayen@atosorigin.com
PostgreSQL version: 8.3.5
Operating system: Ubuntu 8.10
Description: lc_numeric setting ignored
Details:

When setting the LC_NUMERIC to nl_NL.UTF-8 systemvariable at both the OS
level and the database itself (postgresql.conf), the database refuses to
accept a decimal comma.

psql output:

dimpact=# show lc_numeric;
lc_numeric
-------------
nl_NL.UTF-8
(1 row)

dimpact=# select totaalbedragaanslag from import.aanslag;
totaalbedragaanslag
---------------------
33.33
(1 row)

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

He Bruce,

Thank you for replying.
Does this mean that there is no way to do a "\copy from" using CSV files
containing decimals with
a comma?

Mark Hayen

Mark Hayen wrote:

He Bruce,

Thank you for replying.
Does this mean that there is no way to do a "\copy from" using CSV files
containing decimals with
a comma?

That is correct, sorry.

--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +