[QGIS-trac] [Quantum GIS] #1710: wms (mapserver) and postgis: the layer is not added

[Quantum GIS]

#1710: wms (mapserver) and postgis: the layer is not added
------------------------------------------------+---------------------------
   Reporter:  lutra                             |              Owner:  mhugent             
       Type:  bug                               |             Status:  new                 
   Priority:  major: does not work as expected  |          Milestone:  Version 1.2.0       
  Component:  WMS                               |            Version:  HEAD                
   Keywords:  wms, postgis                      |   Platform_version:  Ubuntu 8.10 and 9.04
   Platform:  Debian                            |           Must_fix:  Yes                 
Status_info:  0                                 |  
------------------------------------------------+---------------------------
 I configured a mapserver/wms server and I noticed that if in the mapfile a
 layer is specified as a postgis layer it doesn't appear in the layout when
 is added. At the beginning I supposed to be a problem in the mapfile, but
 then I made tests with two other clients (gvSIG and uDIG) and the layer
 appeared correctly.

 I tested on Ubuntu 8.10 and 9.04 Qgis from 1.0.2 to 1.1 (from repository)
 and 1.2 (compiled from trunk today) and all presented the same behavior.

 if you need to do tests you can use the following address

 http://mapserver.uevora.pt/cgi-bin/ue_wms

 in the available layers you'll see

 "country" is a shapefile

 "Cont_Freg_v2" is a shapefile

 "topo_c" is postgis

 "avif" is postgis

 "ferrovias" is a shapefile


 postgis layers are defined as the following


 {{{
 LAYER
       NAME  "avif"
       METADATA
             "wms_title"   "Avifauna"
             "wms_abstract"  "Zonas de Protecção Especial para a Avifauna"
         END
 PROJECTION
 "init=epsg:20790"
 END
       TYPE           POLYGON
       STATUS         ON
       CONNECTION     "user=*** password=*** dbname=*** host=localhost
 port=5432"
       CONNECTIONTYPE postgis
       DATA           "the_geom from avif"
       DUMP           TRUE
       CLASS
          NAME        "Avifauna"
                 STYLE
                 OUTLINECOLOR 0 0 0
                 COLOR 70 123 20
                 END
       END
    END

 }}}

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