On Sat, Aug 25, 2007 at 07:19:00PM +0300, Niko Tyni wrote:
> 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,
This helped immensely. At least now I know the Time::Local issue is
unrelated and the script successfully inserts into the database. Thanks
very much.
Regards,
-Roberto
--
Roberto C. Sánchez
http://people.connexer.com/~roberto
http://www.connexer.com
Attachment:
signature.asc
Description: Digital signature