[postgis-users] Mapserver and postgis views

[Paul Moen]

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" <matteo.rossi at uniroma1.it> 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