ECPGdo fails to restore LC_NUMERIC

From: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
To: PostgreSQL Bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: ECPGdo fails to restore LC_NUMERIC
Date: 2011-09-01 11:27:07
Message-ID: 4E5F6C0B.6030708@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

ECPGdo function in ecpglib sets LC_NUMERIC locale temporarily to C, to
make sure it uses the '.' as the decimal separator for any numerics it
sends to the backend. However, it fails to restore it back to the
original locale in some error cases. I can see two returns from the
function that neglect that, on lines 1776 and 1803 in execute.c.

Attached is a test program to showcase the first of those. It produces
this output for me:

LC_NUMERIC before: fi_FI.utf8
number: 1,230000
LC_NUMERIC after: C
number: 1.230000

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com

Attachment Content-Type Size
autoprep-setlocale.pgc text/plain 439 bytes

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Kevin Grittner 2011-09-01 13:42:05 Re: The translation into Bulgarian
Previous Message Lampa 2011-09-01 09:59:02 Re: BUG #6186: out of memory while analyze