Have him dump the table again (if he can) using pg_dump's "proper inserts" switch turned on. Tom, I'm not contradicting that the problem may be directly linked to CR's in the data. I have encountered this before and I worked around it with proper inserts. I was working in Linux and never transferred the file anywhere.
--rob
----- Original Message -----
Sent: Friday, August 24, 2001 2:23 AM
Subject: Re: problems transfering databases
Hello, Tom, nope, no windows here. The file was sent direclty from the Linux to my mailbox, which I read on Solaris.
The only thing I can think of is the PostgreSQL versions. My collegue is using 7.0.3, and I use 7.1.2. Comments?
Miroslav
Tom Lane wrote:
Miroslav Koncar <miroslav.koncar@etk.ericsson.se> writes:
> Since it is a simple test database, the 2001-06-04db.out file was around
> 40kB, so he has sent it to me via email. Email huh? I bet some part of that process was Windows? Almost
certainly that's where the carriage return characters came from.
regards, tom lane
--
Miroslav Koncar
Software Engineer
Ericsson Nikola Tesla
ETK/D/R
Tel: +385 1 365 3479
Fax: +385 1 365 3548
mailto:miroslav.koncar@etk.ericsson.se