| From: | Jonatan Reiners <jreiners(at)encc(dot)de> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: problem with pg_dump |
| Date: | 2012-07-31 10:06:18 |
| Message-ID: | 333ADBFC247E4DF9A96E6CCCDB9CD64E@encc.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
First, thanks for that link, i was ignorant.
Process used:
Export database with 'pg_dump icon > save.sql' ( from Mac OS X, pg 9.1.4 )
Import database with 'psql icon < save.sql ( onto Ubuntu, pg 9.1.4 )
The old problem vanished after an update on mac os from 9.1.3 to 9.1.4.
Another problem with tables with money values emerged.
Log excerp:
ERROR: invalid input syntax for type money: "Eu67.667,00"
CONTEXT: COPY bank_transactions, line 1, column amount: "Eu67.667,00"
Similar errors for all tables with money column.
Any hint or suggestions?
Kind regards and thanks for your precious help.
Jonatan
--
Jonatan Reiners
Am Freitag, 27. Juli 2012 um 18:22 schrieb Tom Lane:
>
> http://wiki.postgresql.org/wiki/Guide_to_reporting_problems
>
> regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Kellerer | 2012-07-31 12:13:17 | Re: problem with pg_dump |
| Previous Message | Tom Lane | 2012-07-31 00:59:22 | Re: very slow update query |