#12111: contrig.gis - postgis adaptor spurious warnings about geometry escaping
in
SQL
-----------------------------------------+----------------------------------
Reporter: mattrussell | Owner: nobody
Status: new | Milestone: 1.2
Component: GIS | Version: 1.1
Keywords: quoting escape geometry sql | Stage: Unreviewed
Has_patch: 1 |
-----------------------------------------+----------------------------------
When queries which include a geometry are run, PostgreSQL/postgis
complains about the escaping of the geometry WKB string in the query:
WARNING: nonstandard use of \\ in a string literal at character 144
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
LOG: statement: SELECT COUNT(*) FROM "routes" WHERE
ST_Within("routes"."start_point",
ST_GeomFromWKB('\\001\\003\\000\\000\\000\\001\\000\\000\\000\\005\\000\\000\\000\\217V\\321\\232&\\311\\031\\300S)\\324\\\\\\360\\0...@\\217v\\321\\232&\\311\\031\\...@z\\330=\\021pk@@LQ\\312\\262\\370\\003@@z\\330=\\021pK@@lq\\312\\262\\370\\...@s)\\324\\\\\\360\\0...@\\217v\\321\\232&\\311\\031\\300S)\\324\\\\\\360\\020J@',
4326)))
WARNING: nonstandard use of \\ in a string literal at character 144
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
This is a very small patch to get rid of this warning.
{{{
#!sql
SELECT version();
}}}
PostgreSQL 8.4.0 on i686-redhat-linux-gnu, compiled by GCC gcc (GCC) 4.1.2
20080704 (Red Hat 4.1.2-44), 32-bit
{{{
#!sql
SELECT postgis_full_version();
}}}
POSTGIS="1.3.6" GEOS="3.0.0-CAPI-1.4.1" USE_STATS
This should be future proof, see the note
[http://www.postgresql.org/docs/8.1/interactive/sql-syntax.html#SQL-
SYNTAX-CONSTANTS here], in the PostgreSQL 8.1 manual.
--
Ticket URL: <http://code.djangoproject.com/ticket/12111>
Django <http://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To post to this group, send email to django-updates@googlegroups.com
To unsubscribe from this group, send email to
django-updates+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/django-updates?hl=en
-~----------~----~----~----~------~----~------~--~---
