and thanks for your support,
Eric
2014-12-10 15:27 GMT+01:00 Adrian Klaver adrian.kla...@aklaver.com:
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 (.) from stdin;
12345 text
the
dev_my_settings table, everything is ok.
2014-12-10 10:23 GMT+01:00 Eric Svenson esvenso...@googlemail.com:
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?
SUCCESS
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 adrian.kla...@aklaver.com:
On 12/08/2014 06:53 AM, Eric Svenson wrote:
Hi Adrian,
I try to get
...@aklaver.com:
On 12/08/2014 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
The PostgreSQL RDBMS, version 9.2, packaged by EnterpriseDB
Regards,
Eric
2014-12-05 16:22 GMT+01:00 Adrian Klaver adrian.kla...@aklaver.com:
On 12/05/2014 01:13 AM, Eric Svenson wrote:
Hi Adrian,
Is the above how the message was actually presented or has a
partialtranslation taken place? Just asking because it would seem to
indicate
further
(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
2014-12-04 15:23 GMT+01:00 Adrian
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 esvenso...@googlemail.com:
So what if you load to the VM Postgres using the psql from the host?
I tried that: On the host I started psql
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
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