[Gdal-dev] ogr2ogr, postgis, s57 & enforce_dims_wkb_geometry

Tore Halset halset at pvv.ntnu.no
Tue Feb 8 06:11:54 EST 2005


Hello.

I have installed the following on my mac with Mac OS X 10.3.7:
postgresql-8.0.1
postgis-1.0.0-rc2
gdal-1.2.5

I am trying to load a single S-57 cell into the database, but the first 
insert fails.
LOG:  statement: INSERT INTO "airare" (wkb_geometry , "rcid", "prim", 
"grup", "objl", "rver", "agen", "fidn", "fids", "lnam", "catair", 
"scamin") VALUES (GeometryFromText('POINT (15.47197780 
78.24509130)'::TEXT,1) , 684, 1, 2, 2, 1, 340, 1334049, 50002, 
'015400145B21C352', '2', 270000)
ERROR:  new row for relation "airare" violates check constraint 
"enforce_dims_wkb_geometry"

This is the same error with another cell:
LOG:  statement: INSERT INTO "achare" (wkb_geometry , "rcid", "prim", 
"grup", "objl", "rver", "agen", "fidn", "fids", "lnam", "catach", 
"status", "scamin") VALUES (GeometryFromText('POINT (16.82046390 
77.82454520)'::TEXT,1) , 476, 1, 2, 4, 1, 340, 953081, 50004, 
'0154000E8AF9C354', '1', '3', 360000)
ERROR:  new row for relation "achare" violates check constraint 
"enforce_dims_wkb_geometry"

The enforce_dims_wkb_geometry constraint are equal in airare and achare:
     "enforce_dims_wkb_geometry" CHECK (ndims(wkb_geometry) = 3)

Anyone knows how this can be fixed?

Regards,
  - Tore.




More information about the Gdal-dev mailing list