yes I'll try. But not today. Can you wait a couple of days?
2013/4/8 [email protected] <[email protected]>
> 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
>
------------------------------------------------------------------------------
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
