Beefy Boxes and Bandwidth Generously Provided by pair Networks
P is for Practical
 
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)

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 avoiding work at the Monastery: (7)
As of 2016-10-01 19:50 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    How many different varieties (color, size, etc) of socks do you have in your sock drawer?






    Results (6 votes). Check out past polls.