[QGIS-trac] Re: [Quantum GIS] #2189: Map Server Export - POSTGIS data

[Quantum GIS]

#2189: Map Server Export - POSTGIS data
-----------------------------------------------------+----------------------
        Reporter:  smccabe33                         |         Owner:  rduivenvoorde
            Type:  bug                               |        Status:  closed       
        Priority:  major: does not work as expected  |     Milestone:  Version 1.6.0
       Component:  Python plugins and bindings       |       Version:  HEAD         
      Resolution:  wontfix                           |      Keywords:               
Platform_version:                                    |      Platform:  Debian       
        Must_fix:  No                                |   Status_info:  1            
-----------------------------------------------------+----------------------
Changes (by rduivenvoorde):

  * status:  assigned => closed
  * resolution:  => wontfix


Comment:

 we quote table-identifiers, but NOT column identifiers anymore(?):

 Given a postgresql table named foo with a geometry column name geom

 the following DATA strings are working:

 'geom from "foo" USING UNIQUE gid USING srid=28992' (<- this one we build)

 'geom from foo USING UNIQUE gid USING srid=28992'

 "geom from foo USING UNIQUE gid USING srid=28992"

 trying to quote the column name:

 '"geom" from "foo" USING UNIQUE gid USING srid=28992'

 raises an mapserver exception:

 msDrawMap(): Image handling error. Failed to draw layer named 'foo'.
 msPostGISLayerWhichShapes(): Query error. Error (ERROR: zero-length
 delimited identifier at or near """" LINE 1: select
 encode(AsBinary(force_collection(force_2d(""geom"")),... ^ ) executing
 query: select
 encode(AsBinary(force_collection(force_2d(""geom"")),'NDR'),'hex') as
 geom,"gid" from "foo" where "geom" && GeomFromText('POLYGON((63988.550219
 408504.55046,63988.550219 464973.449801,120457.44956
 464973.449801,120457.44956 408504.55046,63988.550219
 408504.55046))',28992) and ( GeometryType("geom") IN
 ('POINT','MULTIPOINT') )

 There is some mixing up with quotes IN MAPSERVER I think?

 I close this issue given smccabe33 did not provided further info, and this
 is more a 'quoting' problem for the mapserver/postgresql combination?

-- 
Ticket URL: <https://trac.osgeo.org/qgis/ticket/2189#comment:10>
Quantum GIS <http://qgis.org>
Quantum GIS is an Open Source GIS viewer/editor supporting OGR, PostGIS, and GRASS formats