my $copySQL = "copy snapshot_$formName 
(name, value, collect_date, omp_id)
                   from ?"
my $sth = $dbh->prepare($copySQL);
$sth->execute($db_input);


##</code><code>##

DBD::Pg::st execute failed: ERROR:  missing data for column "collect_date" at ./getSnapshot.pl line 180, <FORM_OUT> line 103.
Couldn't execute copy snapshot_cco (name, value, collect_date, omp_id) FROM '/tmp/snapshot_mil-newberlin1_cco.input' statement: 7 at ./getSnapshot.pl line 180, <FORM_OUT> line 103.

##</code><code>##

csno,100,20040908,32
alarm1.equip[1]    y    20040908    32
alarm1.equip[10]    y    20040908    32
alarm1.equip[11]    y    20040908    32