> /As far as I can see now that's the main problem: not having a OID field. > Furthermore it should not be an issue of Pmapper because I had the same > problem when testing it in Chameleon. On a mailinglist one mentioned also the > unique-field that should cause the problem. I tried other existing fields as > unique without result. We keep on trying... Could you maybe sent me a working > table via shp? I tried also the postgis-imported countries.shp and rivers.shp > from the example-files. / >
just run the shapes through shp2pgsql and write the result to a temp file. Then edit the 'CREATE TABLE ...' part and add 'WITH OIDS'. Load the data and try again if it helps. It seems that unfortunately one cannot add an OID field after table creation, the docs say 'Note that there is no variant of ALTER TABLE that allows OIDs to be restored to a table once they have been removed'. So you just could dump your tables and restore them using the 'WITH OIDS' for the 'CREATE...' part. Maybe one could ask the PostGIS guys to add an optional flag '-O' to shp2pgsql in order to add the 'WITH OIDS' to the resulting SQL. armin
