Wierd error for COPY command - Mailing list pgsql-sql

From Josh Berkus
Subject Wierd error for COPY command
Date
Msg-id web-1385572@davinci.ethosmedia.com
Whole thread Raw
Responses Re: Wierd error for COPY command  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Folks,

I'm getting the following error:

jwnet=# copy elbs_udf from '/home/jwnet/testtransfer/udf.txt'
jwnet-# using delimiters '|' with null as '';
": can't parse "ne 1, pg_atoi: error in "1
jwnet=#

I know from previous experience that this is a garbled error message
indicating that there is a problem on one line of the file.  However,
that particular file has 2 million lines, so finding the problem
without a line number would be nigh impossible.  The log only shows the
same error message.

Ideas, anyone?

-Josh Berkus


pgsql-sql by date:

Previous
From: Christoph Haller
Date:
Subject: view on system tables upgrade?
Next
From: "Nick Fankhauser"
Date:
Subject: How do I create unique IDs for an existing set of records