Re: No date = bad date?

Lynna,

> Does anyone know of some reason why importing a text file that contains no
> data for one date field would cause psql to tell me:
>
> ERROR:  copy: line 1, Bad date external representation ''
> lost synchronization with server, resetting connection

Yes.  For the "blank" date, you need to have an \N marker to indicate a NULL.
Or you need to change your copy parameters to indicate that a zero length
string is a NULL; check the COPY docs for details.

--
-Josh Berkus
 Aglio Database Solutions
 San Francisco