oh my god!!!! arghh, well I would have given up and tried this before but I am just too competitive. But now, arghh, i get this!

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 da
+ta for column "collect_date" at ./getSnapshot.pl line 175, <FORM_OUT>
+ line 102.
[download]

when i do this:

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;
[download]

Seriously, what the hell. Also, when I do the same copy statement from the cmd line, it works. I hate this. I even catch to make sure that $date, which is always there is there and it is.