From: | Theodore Petrosky <tedpet5(at)yahoo(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: more information on OSX pg_dump problem |
Date: | 2002-11-25 00:41:25 |
Message-ID: | 20021125004125.67637.qmail@web41009.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Tom,
I have checked the dump file with hexedit and find
that the lines end with '0A' hex. Only one character.
What is strange is that I have multiple tables, some
of them are going in fine.
Ted
-- Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Theodore Petrosky <tedpet5(at)yahoo(dot)com> writes:
> > COPY "fcopenjobs" FROM stdin;
> > If I copy and paste the lines (from the dump file)
> > into psql one by one, it will input fine. However,
> If
> > I cut and paste more that two lines, the input
> fails.
>
> I'm wondering about newline representations, myself.
> Is it possible
> that you've got CR or CR/LF newlines, and not LF
> newlines, in the
> dump file? COPY presently only likes LF
> (Unix-style) newlines.
>
> regards, tom lane
__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
From | Date | Subject | |
---|---|---|---|
Next Message | paolo manca | 2002-11-25 11:10:56 | BUG |
Previous Message | Tom Lane | 2002-11-24 22:36:34 | Re: more information on OSX pg_dump problem |