Re: problems transfering databases

Hello Tom,

problem solved! The error was caused by interpreting \N as a special
character, and not what postgreSQL wants it to be. I've solved it by
replaceing all \N with \\N in a texteditor, which made the shell not to
interpret the character.

Thanks for your suggestions and help.

Miroslav

Tom Lane wrote:

> Miroslav Koncar <miroslav(dot)koncar(at)etk(dot)ericsson(dot)se> writes:
> > 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?
>
> That wouldn't produce a carriage-return problem.
>
> It's possible that we're barking up the wrong tree, and that the issue
> is not carriage returns but something else --- I just jumped to that
> conclusion based on the way you presented the error message. But maybe
> the error message was mangled because you were sloppy about cutting-and-
> pasting it into your email, or some such. Have you looked at the data
> to try to narrow down exactly which line is being rejected?
>
> regards, tom lane