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

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 ./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", $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.


Tradez
"Never underestimate the predictability of stupidity"
- Bullet Tooth Tony, Snatch (2001)


Comment on Re^8: DBD::Pg copy issues
Select or Download Code

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://391215]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others pondering the Monastery: (13)
As of 2014-04-25 08:43 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    April first is:







    Results (585 votes), past polls