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
