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)