Hi,
i get errors restoring a 7.2.1 dump into 7.4
the commands were
Version 7.2.1: pg_dump -Ft -b dbname > filename
Version 7.4 pg_restore -d dbname filename
pg_restore: ERROR: literal carriage return found in data
HINT: Use "\r" to represent carriage return.
CONTEXT: COPY Aktionspartner, line 2: "1 Sparkasse
Pfullendorf-Meßkirch Bahnhofstraße 88630 Pfullendorf 07552 /
263-0 User Name 6905162..."
pg_restore: [archiver (db)] error returned by PQendcopy
i read in the mailing list, that others have the same problem. I know, that
COPY no longer supports literal carriage-returns in 7.4
So i would like to know if this problem is by design (of pg_restore), or if
it will be solved in a future release.
thanks,
Uwe