BUG #6144: Postgres ignores locale's p_cs_precedes and n_cs_precedes settings

From: "Eduard Kracmar" <eduard(dot)kracmar(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #6144: Postgres ignores locale's p_cs_precedes and n_cs_precedes settings
Date: 2011-08-03 12:47:47
Message-ID: 201108031247.p73CllZh012204@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 6144
Logged by: Eduard Kracmar
Email address: eduard(dot)kracmar(at)gmail(dot)com
PostgreSQL version: 8.4.8
Operating system: Debian/testing
Description: Postgres ignores locale's p_cs_precedes and
n_cs_precedes settings
Details:

I'm using sk_SK.utf8 locales on Debian/testing. Running postgresql 8.4.8 and
it ignores p_cs_precedes and n_cs_precedes settings in
/usr/share/i18n/locales/sk_SK. Euro sign should follow monetary quantity.

As tested in PHP for example, it works as it should:

$number = 1234.567;
setlocale(LC_MONETARY, 'sk_SK.utf8');
echo money_format('%n', $number); // 1 234,57 €

But in postgres while using money data type with lc_monetary set to
'sk_SK.utf8', € sign is before figure:
€123,45

Also, displaying monetary quatity bigger than 999 gives null, compared to
de_DE.utf8 which gives correct formatting: €1.234,56 (except for euro sign
of course, as mentioned before).

Browse pgsql-bugs by date

  From Date Subject
Next Message simon.marshall 2011-08-03 15:02:20 Postgres running but no postmaster.pid
Previous Message Snehad Agrekar 2011-08-03 11:34:18 BUG #6143: connection problem