DBD::Pg::db do failed: ERROR:  missing data for column "collect_date" at ./getSnapshot.pl line 175, <FORM_OUT> line 102.
Couldn't write COPY STATEMENT to snapshot_btseqp: , ERROR:  missing data for column "collect_date" at ./getSnapshot.pl line 175, <FORM_OUT> line 102.

##</code><code>##

my $row = join("\t",
                       $name,
                       $value,
                       $date,
                       $ompId);
print INPUTFILE "$row\n";
 }
    }

    print INPUTFILE "\\.\n";
    $dbh->do("COPY snapshot_$formName (name, value, collect_date, omp_id) from '$db_input'")
        or die "Couldn't write COPY STATEMENT to snapshot_$formName: $@, " . $dbh->errstr;