[Qgis-developer] unknown geometry type of GEOMETRY in postgis layer

[Gary Sherman]

nitin quick wrote:
> i tried this also but not of use.
> here is some of the commands which i tried and corresponding output
> which i got.
> 
> ogr2ogr -nlt POINT  -f PostgreSQL PG:dbname=mydb
> /home/prince/mainfo_dgn/44g1.dgn
> ERROR 1: INSERT command for new feature failed.
> ERROR:  new row for relation "elements" violates check constraint
> "enforce_geotype_wkb_geometry"
> 
> Command: INSERT INTO "elements" (wkb_geometry , "type", "level",
> "graphicgroup", "colorindex", "weight", "style") VALUES
> (GeomFromEWKT('SRID=-1;LINESTRING (- 0.055 -0.025,0.055 -0.025)'::TEXT)
> , 3, 27, 0, 3, 2, 0)
> ERROR 1: Terminating translation prematurely after failed
> translation of layer elements
Notice that your INSERT statement is attempting to create a feature of
type LINESTRING.

Did you try using -nlt LINESTRING?


-- 
-gary

-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-
Gary Sherman
Micro Resources: http://mrcc.com
  *Geospatial Hosting
  *Web Site Hosting
"We work virtually everywhere"
-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-