Re: initdb failure (was Re: [GENERAL] sequence's plpgsql)

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.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073