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: (view raw, whole thread or download thread mbox)
Lists: pgsql-sql

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

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

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-2018 The PostgreSQL Global Development Group