Re: problems transfering databases

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 -----
From: Miroslav Koncar
To: Tom Lane
Cc: pgsql-general(at)postgresql(dot)org
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(dot)koncar(at)etk(dot)ericsson(dot)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(dot)koncar(at)etk(dot)ericsson(dot)se