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!
Tradez
"Never underestimate the predictability of stupidity"
- Bullet Tooth Tony, Snatch (2001)
when i do 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.
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.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;
Tradez
"Never underestimate the predictability of stupidity"
- Bullet Tooth Tony, Snatch (2001)
In Section
Seekers of Perl Wisdom