Skip site navigation (1) Skip section navigation (2)

Wierd error for COPY command

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Wierd error for COPY command
Date: 2002-04-26 15:42:34
Message-ID: web-1385572@davinci.ethosmedia.com (view raw or flat)
Thread:
Lists: 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

Responses

pgsql-sql by date

Next:From: Nick FankhauserDate: 2002-04-26 15:58:16
Subject: How do I create unique IDs for an existing set of records
Previous:From: Rajesh Kumar MallahDate: 2002-04-26 14:52:31
Subject: abnormal size of the on-disk file.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group