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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
