On Fri, 26 Sep 2003, Bruce Momjian wrote:
> scott.marlowe wrote:
> > The attached file produces this problem. Note it's a blank trailing field
> > that looks to be causing it. The error for this .sql file is:
> >
> > ERROR: literal carriage return found in data
> > HINT: Use "\r" to represent carriage return.
> > CONTEXT: COPY FROM, line 2
> >
> > Note that loading this into pico and saving it back out fixes the problem.
> >
> > If I remove the preceding row that doesn't end in a blank field, I get a
> > different error, this one:
> >
> > ERROR: end-of-copy marker does not match previous newline style
> > CONTEXT: COPY FROM, line 2
>
> OK, 'vi' shows it as:
>
> COPY people2 (id, persons) FROM stdin;
> 59 Chance Terry--S
> 60 ^M
> \.
>
> which is _exactly the case the error was supposed to catch. Now, the
> big question is where did this dump come from? Pg version? OS platform?
The originating system is a RedHat 7.2 box with postgresql 7.2.x running
on it.
The destination system is a RedHat 7.2 box with postgresql 7.4 beta3
running on it.
The data likely came out of a (gasp, horrors) windows box.