Ok good, I take it you are on master branch. Could you please try the hotfix/3.2.1 branch ?
> I use soci from git download of about 1 week ago > > > 2013/4/8 [email protected] <[email protected]> > >> Hi Bruno >> >> What version of soci are you using ? >> >> It looks a bit like the Postgres regression that went into 3.2.0 >> >> See commit c8ad2a884 for details. It should be fixed in 3.2.1. >> >> Poul >> >> > I tried with the escape beckslash \ (that is \:\:box3d) but the error >> was >> > the same. >> > Then I tried to change the cast syntax as suggested by Mateusz and the >> > query worked. >> > Could be a good idea to add an escape strategy like that one of the >> > backslash (\) for parsing the colons. >> > Do I add the feature request on github? >> > >> > thanks for the replies, >> > Bruno >> > >> > >> > 2013/4/6 Vadim Zeitlin <[email protected]> >> > >> >> On Sat, 6 Apr 2013 14:02:09 +0100 Mateusz Loskot <[email protected]> >> >> wrote: >> >> >> >> ML> > the application gives my the following error: >> >> ML> > >> >> ML> > "Wt: fatal error: ERROR: syntax error at or near ""$1"" >> >> ML> > LINE 1: ...etsrid('BOX3D(15.0118 37.4667, 15.2118 >> 37,6667)'::$1, >> >> 4326) ... >> >> ML> > >> >> ML> > the error is given in place of $1 that in the query is ::box3d. >> >> Why? >> >> there >> >> ML> > was this traslation? >> >> ML> >> >> ML> I haven't tested your query in action, but I suppose there may be >> >> conflict >> >> ML> between casting operators and how SOCI parses query to handle >> >> ML> placeholders bound by name: >> >> ML> >> >> ML> http://soci.sourceforge.net/doc/3.2.0/exchange.html#bind_name >> >> >> >> FWIW the code in PostgreSQL backend clearly tries to detect the cast >> >> operators, there are even several cases for this there. >> >> >> >> ML> > Maybe is the double colons that gives the problem? How >> >> ML> > I can fix? How to pass a colon in the sql string? >> >> ML> >> >> ML> Can you try the alternative [1], SQL conformant, syntax for the >> >> cast: >> >> ML> >> >> ML> SetSRID(CAST('BOX3D(15.0118 37.4667, 15.2118 37,6667)' AS box3d), >> >> 4326) >> >> >> >> From reading the code, it also looks like you should be able to use >> a >> >> backslash to escape (each) colon. But I haven't tested this myself. >> >> >> >> Regards, >> >> VZ >> >> >> >> >> >> >> ------------------------------------------------------------------------------ >> >> Minimize network downtime and maximize team effectiveness. >> >> Reduce network management and security costs.Learn how to hire >> >> the most talented Cisco Certified professionals. Visit the >> >> Employer Resources Portal >> >> http://www.cisco.com/web/learning/employer_resources/index.html >> >> _______________________________________________ >> >> soci-users mailing list >> >> [email protected] >> >> https://lists.sourceforge.net/lists/listinfo/soci-users >> >> >> >> >> > >> ------------------------------------------------------------------------------ >> > Minimize network downtime and maximize team effectiveness. >> > Reduce network management and security costs.Learn how to hire >> > the most talented Cisco Certified professionals. Visit the >> > Employer Resources Portal >> > >> http://www.cisco.com/web/learning/employer_resources/index.html_______________________________________________ >> > soci-users mailing list >> > [email protected] >> > https://lists.sourceforge.net/lists/listinfo/soci-users >> > >> >> >> >> >> ------------------------------------------------------------------------------ >> Minimize network downtime and maximize team effectiveness. >> Reduce network management and security costs.Learn how to hire >> the most talented Cisco Certified professionals. Visit the >> Employer Resources Portal >> http://www.cisco.com/web/learning/employer_resources/index.html >> _______________________________________________ >> soci-users mailing list >> [email protected] >> https://lists.sourceforge.net/lists/listinfo/soci-users >> > ------------------------------------------------------------------------------ > Minimize network downtime and maximize team effectiveness. > Reduce network management and security costs.Learn how to hire > the most talented Cisco Certified professionals. Visit the > Employer Resources Portal > http://www.cisco.com/web/learning/employer_resources/index.html_______________________________________________ > soci-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/soci-users > ------------------------------------------------------------------------------ Minimize network downtime and maximize team effectiveness. Reduce network management and security costs.Learn how to hire the most talented Cisco Certified professionals. Visit the Employer Resources Portal http://www.cisco.com/web/learning/employer_resources/index.html _______________________________________________ soci-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/soci-users
