[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:  assigned     
        Priority:  major: does not work as expected  |     Milestone:  Version 1.4.0
       Component:  Build/Install                     |       Version:  HEAD         
      Resolution:                                    |      Keywords:               
Platform_version:                                    |      Platform:  Debian       
        Must_fix:  No                                |   Status_info:  0            
-----------------------------------------------------+----------------------
Comment (by rduivenvoorde):

 the plugin does already do this (adding "using unique ...") via some
 guessing based on column names...
 So my guess is that the column names or tablenames of smccabe33 were non-
 lowercase, so after adding the quotes those names did not match any more
 (while when removing the quotes: postgresql are always "folded to
 lowercase" it was ok).

 By the way: the FILTER-examples look exactly the same for me in the
 example above, but I think it's the same problem.

 Bringing it back to the question (I think): "should or should we not put
 quotes around column and table names in DATA and FILTER rulse" in the
 mapfile.

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