Search Postgresql Archives

Re: Fwd: Fwd: Problem with pg_dump and decimal mark

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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   text   0   123.345345

This file ALONE works! (without changing ANYTHING!)

So if I run the first (huge) SQL file and then the second, which fills the dev_my_settings table, everything is ok.

2014-12-10 10:23 GMT+01:00 Eric Svenson <esvenson74@xxxxxxxxxxxxxx>:
> 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! This works OK!

INSERT INTO dev_my_settings(123, 'test', 'test', 'test', 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 <adrian.klaver@xxxxxxxxxxx>:
On 12/08/2014 06:53 AM, Eric Svenson wrote:
Hi Adrian,

I try to get access to the non-VM machine, at the moment access is not
possible for me unfortunately.

You are right, there are more tables in the database which are restored
correctly but these tables do NOT contain float values. These two tables
are the only tables in the database which contain floats.

The errors occur with the first float in the table, the restore process
seems to terminate with that table and seems to continue with the next
table. The result are completely empty tables for dev_my_settings and
file_item.

There are float values in the table which can be viewed with pg_admin.

The table definitions for dev_my_settings and file_item contain lots of
BIGINTS, smallints and integers, and several double precision values.
All other tables do not contain any double precision values.

Alright a chance to think some more.

So:

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?

While you are in psql, what does SHOW ALL display for the lc_* settings?

On the Windows server where the Postgres server is running what does SET show from the command line?



Regards,
Eric




--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux