thanks for your support,
Eric
2014-12-10 15:27 GMT+01:00 Adrian Klaver :
>
> On 12/10/2014 01:32 AM, Eric Svenson wrote:
>
>> So, one more success...
>>
>> I have taken a part of the backup SQL file which fills the table
>>
>> COPY dev_my_settings (.
;, 123, 123.345);
Value 123.345 can be read from pg_admin.
SHOW ALL shows English_United States.1252 for all lc_ settings (but I have
tried it with German and C locale with same results)
Regards, Eric
2014-12-08 22:57 GMT+01:00 Adrian Klaver :
> On 12/08/2014 06:53 AM, Eric Svenson wrote:
>
&
dev_my_settings table, everything is ok.
2014-12-10 10:23 GMT+01:00 Eric Svenson :
> > The restore left you with two empty tables. What happens if you log into
> Postgres > via psql and then INSERT one set of values containing floats
> into say, >dev_my_settings?
>
>
TEXT: COPY file_item, line 54, column fi_latitude: "48.2000829"
WARNING: errors ignored on restore: 2
Regards,
Eric
2014-12-05 16:22 GMT+01:00 Adrian Klaver :
> On 12/05/2014 01:13 AM, Eric Svenson wrote:
>
>>
>>
>> Hi Adrian,
>>
>> Is the above
12:21 AM, Eric Svenson wrote:
>
>> Hi Adrian,
>>
>> here are the results of today:
>>
>> > How where the Postgres instances installed?
>> > From a package?
>>
>> Yes. It is Version 9.2 for Windows, comment of the package is
>
"ERROR" (english) "KONTEXT" (german, one line
below) ??
To add further confusion: I have a report that the error also appeared on a
non-VM native PC with Windows 7 Enterprise. Unfortunately, I dont have the
exact error message, but I try to get it ASAP.
regards,
Eric Svenson
dev_my_settings, line xxx, column xxx: "0.2"
ERROR: invalid input syntax for type double precision "15.776653623"
Regards,
Eric Svenson
2014-12-04 11:00 GMT+01:00 Eric Svenson :
> > So what if you load to the VM Postgres using the psql from the host?
>
> I tried
r did you use the psql on the host?
psql on the VM
> Was the Postgres/psql on the host the same as the VM?
Same Version (9.2.1)
> What are you using for virtualization?
VM Ware Player 6.0.2
> What is host OS?
Windows 7 Enterprise SP 1 (see above)
Again, thank you for the support.
Regards,
Eric Svenson
OSIX, but we keep LC_NUMERIC set to "C" to force it to
>> only believe that "." is decimal point.
>>
>
> Not sure if this makes a difference but if I am reading the original post
> correctly the OP was trying a plain text restore via psql.
This is correct.
regards and thanks for your support,
Eric Svenson
precision: 0.1001)
When I change the value in the sql file manually to 0,1001 the and
try again, the restore resumes until the next double value.
How is this possible? Does psql really expect comma-seperated decimal
values in the sql file? How can I change this behaviour?
Regards,
Eric
10 matches
Mail list logo
