[postgis-users] Mapserver and postgis views

[matteo rossi]

Hi,
did anyone experiment some trouble managing postgis view with Mapserver?

We compiled a mapfile with a layer connected to the the_geom attribute 
of a postgis View, but it didn't work.

Here's the code

LAYER
     NAME            "dighe"
     CONNECTION        "user=postgres password=postgres dbname=csrl 
host=localhost port=5432"
      CONNECTIONTYPE     postgis
     STATUS            ON
     DATA            "the_geom from view_dighe_mapserver"
     TYPE             POINT
     CLASS
       [...]

The view works perfectly if managed by Qgis, so the problem is in MapSever.

Thanks

Matteo Rossi

-- 
Dott.Ing. Matteo Rossi
Phd in Environmental Engineering
Dept. Hydraulics, Transportations and Roads
Faculty of Engineering
University "La Sapienza" of Rome

tel: +39 0644585024
fax: +39 0644585016
web: http://geoingegneria.dits.uniroma1.it/
mailto: matteo.rossi at uniroma1.it