Re: Bug #762: copy table from '/home/postgres/import' using - Mailing list pgsql-bugs

From Stephan Szabo
Subject Re: Bug #762: copy table from '/home/postgres/import' using
Date
Msg-id 20020909135238.O16355-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Bug #762: copy table from '/home/postgres/import' using delimiters ',' errors on first line.  (pgsql-bugs@postgresql.org)
List pgsql-bugs
On Mon, 9 Sep 2002 pgsql-bugs@postgresql.org wrote:

> Long Description
> When I attempt to populate an empty table using copy from (specificaly
> while using a comma as the delimiter) I recieve an atoi error on the
> first row and the copy fails. If I add a comma to the end of the first
> row, I get a warning message about extra fields being ignored and the
> copy completes successfuly.
>
> The file I am using to copy from is generated by an oracle application
> that is saved onto a windows desktop and ftp'd to the linux machine
> running PostgreSQL.

Are you perhaps running into an end of line difference problem?  You
probably are getting CRLF vs LF.

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: _bt_check_unique checks every row in table when doing update??
Next
From: Bruce Momjian
Date:
Subject: Re: Unable to compile 7.3beta1 on cygwin