develooper Front page | perl.dbi.users | Postings from March 2005

prepare() bug?

Thread Next
From:
Brandon Metcalf
Date:
March 23, 2005 13:11
Subject:
prepare() bug?
Message ID:
Pine.LNX.4.58L.0503231507480.24435@cash.rhiamet.com
I have several cases where if I try to prepare() a statement and then
execute() it, I get the following:

  DBD::Pg::st execute failed: ERROR:  column "report_time" is of type integer but expression is of type character varying
  HINT:  You will need to rewrite or cast the expression.

However, if I execute the same statement using do() it works.  Is this
a known issue?

-- 
Brandon

Thread Next


nntp.perl.org: Perl Programming lists via nntp and http.
Comments to Ask Bjørn Hansen at ask@perl.org | Group listing | About