[QGIS-trac] [Quantum GIS] #1107: Mapfile export - DATA parameter does not work for the case sensitive PostGIG table names

Quantum GIS qgis at qgis.org
Fri May 23 17:37:35 EDT 2008


#1107: Mapfile export - DATA parameter does not work for the case sensitive
PostGIG table names
---------------------------------------------------------+------------------
   Reporter:  str238                                     |              Owner:  nobody     
       Type:  bug                                        |             Status:  new        
   Priority:  critical: causes crash or data corruption  |          Milestone:  Version 1.0
  Component:  MapServer export                           |            Version:  HEAD       
   Keywords:                                             |   Platform_version:             
   Platform:  All                                        |           Must_fix:  No         
Status_info:  0                                          |  
---------------------------------------------------------+------------------
 The DATA parameter is incorrectly written into the mapfile when PostGIS
 layer used. There are no double quotation used for the table name and that
 is why the case sensitive table names in PostGIS database are not found.

 {{{
 DATA 'the_geom FROM public.CN_2007_orez'
 }}}

 should be like (schema and geometry column name can be case sensitive as
 well)


 {{{
 DATA '"the_geom" FROM "public"."CN_2007_orez"'
 }}}

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


More information about the QGIS-trac mailing list