We use Mapserver layers referencing views in Postgis with no problems. The only difference I see is we have a data line like
geom from gispod using SRID=2266 using unique pod_index where we explicitly assign the SRID and the unique field in the data line. I assume that the postgres user is the owner of the view. Hope that helps. Paul On 10/5/07 8:54 AM, "matteo rossi" <[EMAIL PROTECTED]> wrote: > 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 _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
