On Wed, 17 Aug 2011, David Johnston wrote:
> To be honest I was too and maybe I somehow implied that to you. Anyway, I
> believe if you are dealing with CSV import then you are correct but
> apparently SQL is not as forgiving. I use a third-party application to
> import my CSV usually so whether that observation applies to PSQL or other
> mechanisms (like pg_loader) I cannot say.
David,
It may well be different between COPY and INSERT INTO. Anywho, I altered
the column and set the default to NULL. That works.
Regards,
Rich