From: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
---|---|
To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Peter Eisentraut <peter_e(at)gmx(dot)net>, Tim McAuley <mcauleyt(at)tcd(dot)ie>, <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: initdb failure (was Re: [GENERAL] sequence's plpgsql) |
Date: | 2003-09-26 20:09:21 |
Message-ID: | Pine.LNX.4.33.0309261409030.1165-100000@css120.ihs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers pgsql-jdbc |
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.
Figured out iv (-b switch, man pages rock) and it's a ^M
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2003-09-26 20:22:08 | Re: initdb failure (was Re: [GENERAL] sequence's plpgsql) |
Previous Message | scott.marlowe | 2003-09-26 20:08:28 | Re: initdb failure (was Re: [GENERAL] sequence's plpgsql) |
From | Date | Subject | |
---|---|---|---|
Next Message | Marc G. Fournier | 2003-09-26 20:12:58 | Re: 2-phase commit |
Previous Message | scott.marlowe | 2003-09-26 20:08:28 | Re: initdb failure (was Re: [GENERAL] sequence's plpgsql) |
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2003-09-26 20:22:08 | Re: initdb failure (was Re: [GENERAL] sequence's plpgsql) |
Previous Message | scott.marlowe | 2003-09-26 20:08:28 | Re: initdb failure (was Re: [GENERAL] sequence's plpgsql) |