Front page | perl.dbi.users |
Postings from March 2005
Re: prepare() bug?
Thread Previous
|
Thread Next
From:
Brandon Metcalf
Date:
March 23, 2005 14:02
Subject:
Re: prepare() bug?
Message ID:
Pine.LNX.4.58L.0503231601580.24435@cash.rhiamet.com
b == bmetcalf@nortel.com 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
Thread Previous
|
Thread Next