http://qs1969.pair.com?node_id=20368


in reply to Difficulty inserting a large object using DBD::Pg

I've never had a problem with the semicolon, but leaving it out seems to make no difference.

Yes, I do get an error with what you suggested. Here's what I tried:

$value = "foo"; # test value $dbh->do("insert into foo(id, test) values (6,?)",undef,$value);
It also gives a pg_atoi error for dbh->errstr:
ERROR: pg_atoi: error in "foo": can't parse "foo"