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

Re: Bad Date field

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peralta Miguel-MPERALT1 <Miguel(dot)Peralta(at)motorola(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Bad Date field
Date: 2001-11-29 18:32:51
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
Peralta Miguel-MPERALT1 <Miguel(dot)Peralta(at)motorola(dot)com> writes:
> COPY release_data FROM '/home/mperalta/release_data' USING DELIMITERS '|'
> When I issue this command, the response afte a while is the following:
> ERROR; Bad date external representation '9'
> The external file is rather large and I've tried finding this bad date
> manually with no success.

How old is your Postgres?  The last several releases include line
numbers when complaining about COPY problems.

In the meantime, I like the other person's suggestion about importing
into a temp table and then working with the temp table to clean up
the data.

			regards, tom lane

In response to

pgsql-admin by date

Next:From: Stephan SzaboDate: 2001-11-29 18:39:41
Subject: Re: Vaccum
Previous:From: banghDate: 2001-11-29 18:32:04
Subject: Re: table test

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