[Gdal-dev] ogr2ogr with PostgreSQL 8.1

[Bart van den Eijnden (OSGIS)]

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