Greg, Switching to 1.42 didn't help, but 1.43 did the trick. I didn't realize that there were newer versions of DBD::Pg. The CPAN install tool kept telling me that DBD::Pg was up to date. Thanks for the help! Peter Darley -----Original Message----- From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx]On Behalf Of Greg Sabino Mullane Sent: Thursday, June 23, 2005 11:50 AM To: pgsql-general@xxxxxxxxxxxxxx Subject: Re: Perl DBI issue -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 > I just installed a new machine with Fedora Core 4 with PostgreSQL 8.0.3. I > also installed DBI::Pg 1.41. When I try to use a query with a placeholder > in it I get the error: "DBD::Pg::st execute failed: ERROR: syntax error at > or near "$1" at character 1". The same query with a value instead of a > placeholder works just fine. The script follows this email. Everything looks fine. There were some weird corner cases in 1.41 that were fixed: it`s possible this is one of them, although it does not lok like it. Can you test out 1.43, the latest version? - -- Greg Sabino Mullane greg@xxxxxxxxxxxx PGP Key: 0x14964AC8 200506230815 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (GNU/Linux) iD8DBQFCuv+IvJuQZxSWSsgRAmfzAJ9UwSZ0+fz3bt+L2nxfZR50YoDU5QCdHUba Enqv/TzwemyCd/hJ1PYFR4E= =BE4q -----END PGP SIGNATURE----- ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
