[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.0
 Component:  postgis  |     Version:  1.4          
Resolution:           |    Keywords:               
----------------------+-----------------------------------------------------
Changes (by robe):

  * milestone:  postgis 1.4.1 => postgis 1.4.0

Comment:

 Okay I brought this up and it is intended new behavior -- notes from Tom
 Lane:
 from pg bug -- http://archives.postgresql.org/pgsql-bugs/2009-
 06/msg00045.php

 Kevin if you want I can fix this one since I can test it or you can fix
 and I'll verify it works -- simple enough that we might as well do in
 1.4.0 - so switching back.
 -------------------------------------------------------------------------
 This is an intended change: RAISE format strings are now processed the
 same as any other string literal.  Personally I'd suggest using '' here
 rather than \' --- more standard, more future-proof, etc.

 (Hmm, there seems to be nothing about it in the release notes ... not
 sure how we overlooked that.)

                         regards, tom lane

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