[Gdal-dev] ogr2ogr with PostgreSQL 8.1

[Bart van den Eijnden (OSGIS)]

Sorry, there seems no apparent need since in the MAP file the unique 
column is overrideable, this is my use case which works fine:

  CONNECTIONTYPE POSTGIS
  CONNECTION "user=postgres dbname=gisarts host=127.0.0.1 port=5432 
password=*****"
  DATA "wkb_geometry from percelen_region USING UNIQUE ogc_fid"

Best regards,
Bart

Bart van den Eijnden (OSGIS) wrote:

> Hi list,
>
> shouldn't the tables created by ogr2ogr explicitly specify WITH OIDS? 
> AFAIK all the Mapserver SQL assumes there is an OID column. I am using 
> the latest FWTools.
>
> CREATE TABLE percelen_region
> (
>  ogc_fid int4 NOT NULL DEFAULT 
> nextval('percelen_region_ogc_fid_seq'::regclass),
>  wkb_geometry geometry,
>  aanduid char(12),
>  gemcod char(5),
>  sectie char(2),
>  nummer char(5),
>  secnum char(7),
>  hoek numeric(8,3),
>  CONSTRAINT enforce_dims_wkb_geometry CHECK (ndims(wkb_geometry) = 2),
>  CONSTRAINT enforce_geotype_wkb_geometry CHECK 
> (geometrytype(wkb_geometry) = 'MULTIPOLYGON'::text OR wkb_geometry IS 
> NULL),
>  CONSTRAINT enforce_srid_wkb_geometry CHECK (srid(wkb_geometry) = -1)
> )
> WITHOUT OIDS;
>
> Best regards,
> Bart
>


-- 
Bart van den Eijnden
OSGIS, Open Source GIS
http://www.osgis.nl