Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"

Re^8: DBD::Pg copy issues

by tradez (Pilgrim)
on Sep 15, 2004 at 15:40 UTC ( #391215=note: print w/replies, xml ) Need Help??

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 ./ line 175, <FORM_OUT> line 102. Couldn't write COPY STATEMENT to snapshot_btseqp: , ERROR: missing da +ta for column "collect_date" at ./ line 175, <FORM_OUT> + line 102.
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;
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)

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://391215]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others having an uproarious good time at the Monastery: (6)
As of 2018-02-21 20:11 GMT
Find Nodes?
    Voting Booth?
    When it is dark outside I am happiest to see ...

    Results (287 votes). Check out past polls.