Re: Fwd: Problem with pg_dump and decimal mark

On 12/03/2014 12:23 AM, Eric Svenson wrote:
>
> Hi Adrian,
>
> thank you for your support. Here are the informations you requested
>
>
> I have already done that and found something strange:
>
> On the PC where the backup was done with pg_dump, all locale settings of
> Postgres were English/United States. (LC_COLLATE, LC_CTYPE, LC_MONETARY,
> LC_NUMERIC in postgresql.conf)
>
>
> > OS and OS version?
>
> Windows Server 2012R2
>
> > Postgres version?
>
> Version 9.2.1 (same version used on all machines)
>
> > What was the pg_dump command used?
>
> pg_dump -p 6789 -EUTF8 -f myFile.sql my_Database
>

> > How was it loaded via psql?
>
> psql -p 6789 -U postgres my_Database < myFile.sql
>
> > Was the psql on the same machine and from the same version of Postgres?
>
> Same version, but on different machines.
>
>
> On the second PC (Virtual Machine) I had the SAME settings in
> postgresql.conf (German_Germany)
>
>
> > OS and OS version?
>
> Windows 7 Ultimate SP 1
>
> > Postgres version?
>
> Version 9.2.1 (same version used on all machines)
>
> > How was it loaded via psql?
>
> psql -p 6789 -U postgres my_Database < myFile.sql
>
> > Did you use the psql on the VM or did you use the psql on the host?
>
> psql on the VM
>

So what if you load to the VM Postgres using the psql from the host?

>
> Again, thank you for the support.

As Tom said LC_NUMERIC is set to C in main.c:

/*
* We keep these set to "C" always, except transiently in
pg_locale.c; see
* that file for explanations.
*/

The transiently part intrigued me so I went to pg_locale.c and there was
a big:

* !!! NOW HEAR THIS !!!

with regards to resetting locales. Honestly the explanation is beyond my
expertise. I offer it only as a starting point for those that can
understand it.

>
> Regards,
> Eric Svenson

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com