Folks, Regarding DBD-Pg version 1.40 -
I entered this on the CPAN module review today as I have been able to replicate this problem in three situations and reverting back to an earlier module works fine...another user indicated in a separate post that make test fails with undefined obj errors... My code is unremarkable and works with earlier modules as well as on MySQL and Oracle: $query = qq |INSERT INTO sql_login VALUES (?, ?, ?)|; $sth = $dbh->prepare($query); $sth->execute ($log_name, $log_date, $log_time); $sth->finish(); Here is my entry on CPAN...anyone have any info on this problem? Am I being dense or is this a known issue??? TIA, Tom DBD-Pg (1.40) 1 stars The error str (below) appears to indicate a broken quoter() as when I manually quote instead of relying on variable binding I have no such problem. I have two colleagues who have reported the same difficulty with this version of a module that I have used since Edmund Mergl first offered it to the Postgres community. :-( 1.21 works and so I reverted back. As I am not the first person to report a serious bug I am wondering why 1.40 is the most recent patch level on CPAN (???) Here is the stderr from apache (I have no root access and cannot do much more troubleshooting on this box): DBD::Pg::st execute failed: ERROR: column "log_date" is of type date but expression is of type character varying HINT: You will need to rewrite or cast the expression. Thomas Good - 2005-04-06 08:25:59 - edit ----------------------------------------------------------------------- Thomas Good e-mail: [EMAIL PROTECTED] Senior Database Administrator phone: (+1) 718.818.5528 Residential Services fax: (+1) 718.818.5056 Behavioral Health Services, SVCMC-NY mobile: (+1) 347.524.5631
