Re: pg_dump and restore

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: Raw Message | Whole Thread | 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.

In response to

Responses

Browse pgsql-general by date

  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