in reply to
Re^7: DBD::Pg copy issues
in thread DBD::Pg copy issues
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.
when i do this:
my $row = join("\t",
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;
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.
"Never underestimate the predictability of stupidity"
- Bullet Tooth Tony, Snatch (2001)