[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Re: Possible breakage in HTTP::Date or Time::Local



On Fri, Aug 24, 2007 at 08:10:59PM -0700, Don Armstrong wrote:

> > OK.  I made the output more verbose (obviously the phone number is
> > obfuscated):
> > 
> > Adding call 11856261279 to the database...
> >         Using values: 11856261279, Aug 24, 2007 06:30 PM, , 10000000000, Voicemail, 00:01:00
> > ERROR:  syntax error at or near "$2" at character 119
> 
> What I'm missing here is where the "$2" is comming from; knowing the
> actual query (or as close as can be gotten) that is being run would
> help.

This looks like #315708 and #321917: placeholders are now evaluated on
the PostgreSQL server side, which made their syntax rules more strict.

A workaround would be to switch back to local placeholders with

  $dbh->{pg_server_prepare} = 0;

See /usr/share/doc/libdbd-pg-perl/NEWS.Debian.gz .

Hope this helps,
-- 
Niko Tyni   ntyni@iki.fi



Reply to: