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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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. +
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2009-01-13 09:18:57 | Re: [BUGS] Status of issue 4593 |
Previous Message | Mark Hayen | 2009-01-12 21:49:53 | BUG #4612: lc_numeric setting ignored |