Postgres Pro
Downloads
Home   >   mailing lists

copy from file with null date fields - Mailing list pgsql-general

From William D. McCoy
Subject copy from file with null date fields
Date
Msg-id 199806031935.PAA01616@aeolus.geo.umass.edu
Whole thread Raw
List pgsql-general
Tree view 
I'm running Postgres 6.3.2 on a Sparc20 running Solaris 2.5.1 and I'm
having difficulty copying data from certain text files where fields
expected to be type 'date' are null.  When the copy encounters the
null field it stops and prints the message:

ERROR:  Bad date external representation

I have purposely _not_ defined the field as 'not null'.  I have not
had trouble reading from files where other types of fields are null.

Any ideas, or is this a known bug?

--
William D. McCoy
Geosciences
University of Massachusetts
Amherst, MA  01003

pgsql-general by date:

Previous
From: Peter Mount
Date:
Subject: Re: [GENERAL] Graphical database maintenence design tool
Next
From: David Hartwig
Date:
Subject: Re: [GENERAL] copy from file with null date fields