[postgis-users] Mapserver and postgis views
pmoen at nd.gov
Fri Oct 5 07:01:42 PDT 2007
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.
On 10/5/07 8:54 AM, "matteo rossi" <matteo.rossi at uniroma1.it> wrote:
> 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
> 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
> The view works perfectly if managed by Qgis, so the problem is in MapSever.
> Matteo Rossi
More information about the postgis-users