Skip site navigation (1) Skip section navigation (2)

BUG #4612: lc_numeric setting ignored

From: "Mark Hayen" <mark(dot)hayen(at)atosorigin(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4612: lc_numeric setting ignored
Date: 2009-01-12 21:49:53
Message-ID: 200901122149.n0CLnr4N026483@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      4612
Logged by:          Mark Hayen
Email address:      mark(dot)hayen(at)atosorigin(dot)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)

Responses

pgsql-bugs by date

Next:From: Bruce MomjianDate: 2009-01-13 03:48:12
Subject: Re: BUG #4612: lc_numeric setting ignored
Previous:From: Tom LaneDate: 2009-01-12 19:21:08
Subject: Re: [BUGS] Status of issue 4593

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group