[Gdal-dev] trouble loading s57 into postgis

Tore Halset halset at pvv.ntnu.no
Wed Nov 17 09:05:09 EST 2004


Hello.

I have upgraded my database and gis tools to postgresql-8.0.0b4, 
postgis-0.9.0 and gdal-1.2.4.

I get a sql error when I try to import a NOAA ENC into postgis using 
ogr2ogr. Here is the output from postgresql log:

LOG:  statement: INSERT INTO "bcnlat" (wkb_geometry , "rcid", "prim", 
"grup", "objl", "rver", "agen", "fidn", "fids", "lnam", "lnam_refs", 
"ffpt_rind", "bcnshp", "catlam", "colour", "objnam", "status", 
"scamin", "sordat", "sorind") VALUES (GeometryFromText('POINT 
(-97.49502700 27.83072200)'::TEXT,1) , 2, 1, 2, 7, 1, 550, 262591846, 
1161, '02260FA6D5660489', '(2:02260FA6D6040', '{', 4, 2, '', 'Viola 
Channel Light 2', '1', 120000, '19980407', 'US,US,reprt,8thCGD,LNM 
14/98')
ERROR:  malformed array literal: "{"

looks like ogr2ogr tries to put '{' into a integer[].

Regards,
  - Tore.




More information about the Gdal-dev mailing list