prepare() bug?

From: Brandon Metcalf (bmetcalf_at_nortel.com)
Date: 03/23/05 

Date: Wed, 23 Mar 2005 15:11:13 -0600 (CST)
To: dbi-users@perl.org

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

Relevant Pages