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

Re: BUG #4612: lc_numeric setting ignored

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Mark Hayen <mark(dot)hayen(at)atosorigin(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4612: lc_numeric setting ignored
Date: 2009-01-13 03:48:12
Message-ID: 200901130348.n0D3mCt02710@momjian.us (view raw or flat)
Thread:
Lists: pgsql-bugs
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(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)
> 
> -- 
> Sent via pgsql-bugs mailing list (pgsql-bugs(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs

-- 
  Bruce Momjian  <bruce(at)momjian(dot)us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

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

In response to

Responses

pgsql-bugs by date

Next:From: Peter EisentrautDate: 2009-01-13 09:18:57
Subject: Re: [BUGS] Status of issue 4593
Previous:From: Mark HayenDate: 2009-01-12 21:49:53
Subject: BUG #4612: lc_numeric setting ignored

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