On Fri, 26 Sep 2003, Bruce Momjian wrote:
> scott.marlowe wrote:
> > > 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.
>
> OK, try this on your 7.2:
>
> test=> create table test(x text);
> CREATE TABLE
> test=> insert into test values ('\r');
> INSERT 17158 1
> test=> copy test to '/tmp/out';
> COPY
>
> Then 'vi' /tmp/out. It should show \r, not ^M. Please report back.
I'm not much of a vi guy, so the out file thing didn't tell me much, but
if I try and dump it from the 7.4 beta3 box into a new table, I get:
ERROR: end-of-copy marker does not match previous newline style
CONTEXT: COPY FROM, line 2