[FWTools] ogrinfo warns about 'Multi-column primary key' but there
is none
Stefan Keller
sfkeller at gmail.com
Tue Dec 11 18:20:00 EST 2007
I have a PostgreSQL table which goes like shon below.
When I'm querying the my db 'gisdb' with ogrinfo it issues a warning:
ogrinfo -ro PG:"dbname=gisdb"
Warning 1: Multi-column primary key in 'towns' detected but not supported.
INFO: Open of `PG:dbname=gisdb'
using driver `PostgreSQL' successful.
1: towns (Multi Polygon)
So the orginfo pretends that there is a "Multi-column primary key" but there
is no primary key.
Someone any explanation on this?
-- Stefan
CREATE TABLE towns
( gid serial NOT NULL, objectid int8, towns_id int8, town_id int4,
town varchar, fips_stco int4, ccd_mcd varchar, fips_place varchar,
pop1980 int4, pop1990 int4, pop2000 int4, popch80_90 int4, popch90_00
int4,
fourcolor int4, "type" varchar, island int4, fips_mcd int4,
fips_count int4, shape_area numeric, shape_len numeric, the_geom geometry,
CONSTRAINT enforce_geotype_the_geom
CHECK (geometrytype(the_geom) = 'MULTIPOLYGON'::text OR the_geom IS
NULL),
CONSTRAINT enforce_srid_the_geom CHECK (srid(the_geom) = 26986)
)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.maptools.org/pipermail/fwtools/attachments/20071212/24efa5c7/attachment.html
More information about the FWTools
mailing list