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