<html>Bart,<br><br>I found the same to be true. PostGIS lists had some discussion about this last year, as 8.1 was due out, but the topic seemed to drop off.<br><br>It appears you can use anything for the key, but that sort of leaves it up to the developer to make sure the identifier is not duplicated somewhere in another table being joined. As the non guru I am, it appears merging tables, that duplicate IDs, could pose a serious problem, not to mention what it might be doing with the geometry_columns table, or other geometry funtions, if duplicated.<br><br>I wonder if the OID drop was a performance or limits issue, and the PostgreSQL developers felt it was better left to the database designers.<br><br>Regards,<br>Paul<br><br>
-----Original Message-----<br>
From: Bart van den Eijnden (OSGIS) [mailto:bartvde@xs4all.nl]<br>
Sent: Monday, January 16, 2006 10:55 AM<br>
To: 'Bart van den Eijnden (OSGIS)'<br>
Cc: gdal-dev@lists.maptools.org<br>
Subject: Re: [Gdal-dev] ogr2ogr with PostgreSQL 8.1<br>
<br>
Sorry, there seems no apparent need since in the MAP file the unique <br>
column is overrideable, this is my use case which works fine:<br>
<br>
CONNECTIONTYPE POSTGIS<br>
CONNECTION "user=postgres dbname=gisarts host=127.0.0.1 port=5432 <br>
password=*****"<br>
DATA "wkb_geometry from percelen_region USING UNIQUE ogc_fid"<br>
<br>
Best regards,<br>
Bart<br>
<br>
Bart van den Eijnden (OSGIS) wrote:<br>
<br>
> Hi list,<br>
><br>
> shouldn't the tables created by ogr2ogr explicitly specify WITH OIDS? <br>
> AFAIK all the Mapserver SQL assumes there is an OID column. I am using <br>
> the latest FWTools.<br>
><br>
> CREATE TABLE percelen_region<br>
> (<br>
> ogc_fid int4 NOT NULL DEFAULT <br>
> nextval('percelen_region_ogc_fid_seq'::regclass),<br>
> wkb_geometry geometry,<br>
> aanduid char(12),<br>
> gemcod char(5),<br>
> sectie char(2),<br>
> nummer char(5),<br>
> secnum char(7),<br>
> hoek numeric(8,3),<br>
> CONSTRAINT enforce_dims_wkb_geometry CHECK (ndims(wkb_geometry) = 2),<br>
> CONSTRAINT enforce_geotype_wkb_geometry CHECK <br>
> (geometrytype(wkb_geometry) = 'MULTIPOLYGON'::text OR wkb_geometry IS <br>
> NULL),<br>
> CONSTRAINT enforce_srid_wkb_geometry CHECK (srid(wkb_geometry) = -1)<br>
> )<br>
> WITHOUT OIDS;<br>
><br>
> Best regards,<br>
> Bart<br>
><br>
<br>
<br>
-- <br>
Bart van den Eijnden<br>
OSGIS, Open Source GIS<br>
http://www.osgis.nl<br>
<br>
_______________________________________________<br>
Gdal-dev mailing list<br>
Gdal-dev@lists.maptools.org<br>
http://lists.maptools.org/mailman/listinfo/gdal-dev<br>
</html>