I see there are a handful of reports of this, but it does seem broken to
me. If I am copying a table and a column is blank, surely it makes sense
to substitute the column default from the table? Right now, it is
substituting 0 for a null column, instead of -99 as I wished, and here I
was complaining that it was the national weather service's bug.
Re: [HACKERS] Bug or feature? COPY ignores column defaults
http://archives.postgresql.org/pgsql-hackers/1999-01/msg00667.phphttp://archives.postgresql.org/pgsql-hackers/1999-01/msg00650.php
Alas, I will have to run perl regex on this awful weather data to make
it work right.
Tim