| From: | Andreas Tille <tillea(at)rki(dot)de> |
|---|---|
| To: | |
| Cc: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: pg_dump and restore |
| Date: | 2000-08-11 09:27:13 |
| Message-ID: | Pine.LNX.4.21.0008111120230.23353-100000@wr-linux02.rki.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello,
after solving the timestamp issue I found out further problems with
the dump from the database. I found out that *some* fields with
German Umlauts make psql fail with *some* records. It is really strange
that *not all* records fail but just a *few* :-(((. Enclosing the
strings in '' in the dump file helped psql and it could read the
records fine, but now they are included with additional '' :-(.
Well, after removing the '' with Access pg_dump cut the remainder
of the record so that the columns behind the string in question remain
empty.
What could cause this very strange trouble after having a correct
database pg_dumped???
Kind regards
Andreas.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Radoslaw Stachowiak | 2000-08-11 09:39:51 | Re: Date storage class type |
| Previous Message | Bob Parkinson | 2000-08-11 09:03:43 | recreate the index |