[Django] #12111: contrig.gis - postgis adaptor spurious warnings about geometry escaping in SQL

[Django-3]

#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\\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.

--
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@...
To unsubscribe from this group, send email to django-updates+unsubscribe@...
For more options, visit this group at http://groups.google.com/group/django-updates?hl=en
-~----------~----~----~----~------~----~------~--~---

[Django-3]

#12111: contrib.gis - postgis adaptor spurious warnings about geometry escaping in
SQL
----------------------------------+-----------------------------------------
          Reporter:  mattrussell  |         Owner:  nobody                    
            Status:  new          |     Milestone:  1.2                        
         Component:  GIS          |       Version:  1.1                        
        Resolution:               |      Keywords:  quoting escape geometry sql
             Stage:  Unreviewed   |     Has_patch:  1                          
        Needs_docs:  0            |   Needs_tests:  0                          
Needs_better_patch:  0            |  
----------------------------------+-----------------------------------------
Changes (by mattrussell):

  * needs_better_patch:  => 0
  * summary:  contrig.gis - postgis adaptor spurious warnings about
              geometry escaping in SQL => contrib.gis -
              postgis adaptor spurious warnings about
              geometry escaping in SQL
  * needs_tests:  => 0
  * needs_docs:  => 0

--
Ticket URL: <http://code.djangoproject.com/ticket/12111#comment:1>
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@...
To unsubscribe from this group, send email to django-updates+unsubscribe@...
For more options, visit this group at http://groups.google.com/group/django-updates?hl=en
-~----------~----~----~----~------~----~------~--~---

[Django-3]

#12111: contrib.gis - postgis adaptor spurious warnings about geometry escaping in
SQL
----------------------------------+-----------------------------------------
          Reporter:  mattrussell  |         Owner:  nobody                    
            Status:  closed       |     Milestone:  1.2                        
         Component:  GIS          |       Version:  1.1                        
        Resolution:  fixed        |      Keywords:  quoting escape geometry sql
             Stage:  Unreviewed   |     Has_patch:  1                          
        Needs_docs:  0            |   Needs_tests:  0                          
Needs_better_patch:  0            |  
----------------------------------+-----------------------------------------
Changes (by Alex):

  * status:  new => closed
  * resolution:  => fixed

Comment:

 Fixed in r11726.

--
Ticket URL: <http://code.djangoproject.com/ticket/12111#comment:2>
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@...
To unsubscribe from this group, send email to django-updates+unsubscribe@...
For more options, visit this group at http://groups.google.com/group/django-updates?hl=en
-~----------~----~----~----~------~----~------~--~---

[Django-3]

#12111: contrib.gis - postgis adaptor spurious warnings about geometry escaping in
SQL
----------------------------------+-----------------------------------------
          Reporter:  mattrussell  |         Owner:  nobody                    
            Status:  closed       |     Milestone:  1.2                        
         Component:  GIS          |       Version:  1.1                        
        Resolution:  fixed        |      Keywords:  quoting escape geometry sql
             Stage:  Unreviewed   |     Has_patch:  1                          
        Needs_docs:  0            |   Needs_tests:  0                          
Needs_better_patch:  0            |  
----------------------------------+-----------------------------------------
Comment (by jbronn):

 This patch will not be backported to 1.1.X because it will break
 compatibility with PostgreSQL versions prior to 8.1 (and compatibility was
 ensured for versions "8.X" in docs).  Users on versions 8.0 and below are
 recommended to set `escape_string_warning = off` in their settings.

--
Ticket URL: <http://code.djangoproject.com/ticket/12111#comment:3>
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@...
To unsubscribe from this group, send email to django-updates+unsubscribe@...
For more options, visit this group at http://groups.google.com/group/django-updates?hl=en
-~----------~----~----~----~------~----~------~--~---

[Django-3]

#12111: contrib.gis - postgis adaptor spurious warnings about geometry escaping in
SQL
----------------------------------+-----------------------------------------
          Reporter:  mattrussell  |         Owner:  nobody                    
            Status:  closed       |     Milestone:  1.2                        
         Component:  GIS          |       Version:  1.1                        
        Resolution:  fixed        |      Keywords:  quoting escape geometry sql
             Stage:  Unreviewed   |     Has_patch:  1                          
        Needs_docs:  0            |   Needs_tests:  0                          
Needs_better_patch:  0            |  
----------------------------------+-----------------------------------------
Comment (by jbronn):

 And by 'settings' I mean `postgresql.conf`.

--
Ticket URL: <http://code.djangoproject.com/ticket/12111#comment:4>
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@...
To unsubscribe from this group, send email to django-updates+unsubscribe@...
For more options, visit this group at http://groups.google.com/group/django-updates?hl=en
-~----------~----~----~----~------~----~------~--~---