[postgis-devel] Re: [PostGIS] #190: populate_geometry_columns gives nonstandard use of \' in a string literal

[PostGIS]

#190: populate_geometry_columns  gives  nonstandard use of \' in a string literal
----------------------+-----------------------------------------------------
  Reporter:  robe     |       Owner:  pramsey      
      Type:  defect   |      Status:  new          
  Priority:  low      |   Milestone:  postgis 1.4.1
 Component:  postgis  |     Version:  1.4          
Resolution:           |    Keywords:               
----------------------+-----------------------------------------------------
Comment (by robe):

 Kevin -- sorry should have mentioned that after the fact -- yah its not
 worth the change I realized for this project I'm working on -- I had
 manually changed the constraints to allow a mix of MULTIPOLYGONS and
 POLYGONS since it was more efficient for the front end to deal with most
 as POLYGONS and there were a few MULTIPOLYGONS in there.  So disregard
 that.

 Regarding the nonstandard use -- this is what I get on 8.4.  though I may
 nto be running the latest version on this box.  This only shows if you
 have "escape_string_warning" set to on.  Which at least on windows is the
 default install.

 WARNING:  nonstandard use of \' in a string literal
 HINT:  Use '' to write quotes in strings, or use the escape string syntax
 (E'...').
 CONTEXT:  string literal in PL/PgSQL function "populate_geometry_columns"
 near line 68
 PL/pgSQL function "populate_geometry_columns" line 52 at assignment
 WARNING:  nonstandard use of \' in a string literal
 HINT:  Use '' to write quotes in strings, or use the escape string syntax
 (E'...').
 CONTEXT:  string literal in PL/PgSQL function "populate_geometry_columns"
 near line 102
 PL/pgSQL function "populate_geometry_columns" line 52 at assignment
 WARNING:  nonstandard use of \' in a string literal
 HINT:  Use '' to write quotes in strings, or use the escape string syntax
 (E'...').
 CONTEXT:  string literal in PL/PgSQL function "populate_geometry_columns"
 near line 146
 PL/pgSQL function "populate_geometry_columns" line 52 at assignment
 WARNING:  nonstandard use of \' in a string literal
 HINT:  Use '' to write quotes in strings, or use the escape string syntax
 (E'...').
 CONTEXT:  string literal in PL/PgSQL function "populate_geometry_columns"
 near line 148
 PL/pgSQL function "populate_geometry_columns" line 52 at assignment
 WARNING:  nonstandard use of \' in a string literal
 HINT:  Use '' to write quotes in strings, or use the escape string syntax
 (E'...').
 CONTEXT:  string literal in PL/PgSQL function "populate_geometry_columns"
 near line 150
 PL/pgSQL function "populate_geometry_columns" line 52 at assignment
 WARNING:  nonstandard use of \' in a string literal
 HINT:  Use '' to write quotes in strings, or use the escape string syntax
 (E'...').
 CONTEXT:  string literal in PL/PgSQL function "populate_geometry_columns"
 near line 198
 PL/pgSQL function "populate_geometry_columns" line 52 at assignment
 WARNING:  nonstandard use of \' in a string literal
 HINT:  Use '' to write quotes in strings, or use the escape string syntax
 (E'...').
 CONTEXT:  string literal in PL/PgSQL function "populate_geometry_columns"
 near line 200
 PL/pgSQL function "populate_geometry_columns" line 52 at assignment
 WARNING:  nonstandard use of \' in a string literal
 HINT:  Use '' to write quotes in strings, or use the escape string syntax
 (E'...').
 CONTEXT:  string literal in PL/PgSQL function "populate_geometry_columns"
 near line 202

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/190#comment:3>
PostGIS <http://trac.osgeo.org/postgis/>
PostGIS