id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
12111	contrib.gis - postgis adaptor spurious warnings about geometry escaping in SQL	mattrussell	nobody	"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\\020J@\\217V\\321\\232&\\311\\031\\300@z\\330=\\021pK@@LQ\\312\\262\\370\\003@@z\\330=\\021pK@@LQ\\312\\262\\370\\003@S)\\324\\\\\\360\\020J@\\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.

"		closed	GIS	1.1		fixed	quoting escape geometry sql		Unreviewed	1	0	0	0	0	0