MapServer PostGIS connection: oids an gids to build a query
Fabio D'Ovidio
dovidio at PLANETEK.IT
Wed May 23 08:44:17 PDT 2007
Hi !!
I have imported some geographical data (POINT) and their alphanumeric information in
PostgreSQL\PostGIS database. The structure of the database is WITHOUT OIDS and there
are no GIDs in the tables. So PK and FK are not numerical keys: they are string type keys!.
I have noticed that GeoServer (and uDIG Desktop side) is able to communicate with
PostGIS without problem: i can display and query my vectorial layers.
MapServer (and QGIS Desktop side), instead, is able to connect and display vectorial data
in PostGIS but it isn't able to query them. I am sure the problem is related to the absence of
OIDS and\or GIDs. So MapServer is able only to query data if they have integer ids in
PostGIS structure. WHY ??
How can I solve this problem ??
A solution could be connect Geoserver to mapserver as a WMS layer, but I'd like to use
ONLY MapServer!
Thanks a lot!
--
Ing. Fabio D'Ovidio
Staff Web GIS
Planetek Italia s.r.l.
Via Massaua 12, I-70123 Bari
Tel.: +39 080 5343750 Fax: +39 080 5340280
dovidio at planetek.it - http://www.planetek.it
--
More information about the MapServer-users
mailing list