b == [EMAIL PROTECTED] writes:
b> Here is a small script that reproduces the problem:
b> $ cat ii
b> #!/usr/bin/perl
b> use strict;
b> use warnings;
b> use lib '/ems_src/lib/modules';
b> use DBI;
b> my $h = 'foo';
b> my $v1 = 382;
b> my $v2 = 1;
b> my $dbh = DBI->connect("dbi:Pg:dbname='mydb';host='dbhost'");
b> my $sth = $dbh->prepare("INSERT INTO host_flags (host,total,active)
VALUES (?,?,?)");
b> $sth->execute($h,$v1,$v2);
b> __END__
b> $ ./ii
b> DBD::Pg::st execute failed: ERROR: column "total" is of type integer but
expression is of type character varying
b> HINT: You will need to rewrite or cast the expression.
Looks like known bug in DBD::Pg:
http://rt.cpan.org/NoAuth/Bug.html?id=11744
--
Brandon
