Re: Fwd: Problem with pg_dump and decimal mark - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Fwd: Problem with pg_dump and decimal mark
Date
Msg-id 54806E74.4070904@aklaver.com
Whole thread Raw
In response to Re: Fwd: Problem with pg_dump and decimal mark  (Eric Svenson <esvenson74@googlemail.com>)
List pgsql-general
On 12/04/2014 02:01 AM, Eric Svenson wrote:
>> So what if you load to the VM Postgres using the psql from the host?
>
> I tried that: On the host I started psql with
> psql -h 192.168.2.55 -U postgres -p 5432 my_Database < myFile.sql
>
> I get the same error
>
> ERROR: invalid input syntax for type double precision "0.2"
> KONTEXT: COPY dev_my_settings, line xxx, column xxx: "0.2"

Is the above how the message was actually presented or has a partial
translation taken place? Just asking because it would seem to indicate
further confusion about the locale.

>
> ERROR: invalid input syntax for type double precision "15.776653623"

Hmm, I'm at a loss. It is not a strict Windows issue as you can restore
on other Windows machines. The remaining suspect would be VMware. VMware
and locales tickles a memory, one that I cannot drag up at the moment.
One of those things where the more you think of it the further it goes
away. We will see if working on other stuff causes it to sneak up on me:)

>
> Regards,
> Eric Svenson
>


--
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: FW: getting error while running sql on mm_activealrm table
Next
From: "Day, David"
Date:
Subject: Re: segmentation fault postgres 9.3.5 core dump perlu related ?