[QGIS-trac] Re: [Quantum GIS] #3641: Bug in ShapeFile to postgis import Tool

[Quantum GIS]

#3641: Bug in ShapeFile to postgis import Tool
----------------------------------------+-----------------------------------
   Reporter:  mickael1                  |              Owner:               
       Type:  bug                       |             Status:  new          
   Priority:  minor: annoyance          |          Milestone:  Version 1.7.0
  Component:  Vectors                   |            Version:  Trunk        
   Keywords:  shapefile postigs import  |   Platform_version:  windows seven
   Platform:  Windows                   |           Must_fix:  No           
Status_info:  0                         |  
----------------------------------------+-----------------------------------
Changes (by jef):

 * cc: code, revision, 15530 (removed)


Old description:

> Once I've created a shapefile with dxf2shp module, I tried to use the
> module : shapefile to postis, but i got :
>
> The database gave an error while executing this SQL:
> SELECT AddGeometryColumn('public','test1','the_geom',-1,'NULL',2)
> The error was:
> ERREUR:  Invalid type name - valid ones are:
>         POINT, MULTIPOINT,
>         LINESTRING, MULTILINESTRING,
>         POLYGON, MULTIPOLYGON,
>         CIRCULARSTRING, COMPOUNDCURVE, MULTICURVE,
>         CURVEPOLYGON, MULTISURFACE,
>         GEOMETRY, GEOMETRYCOLLECTION,
>         POINTM, MULTIPOINTM,
>         LINESTRINGM, MULTILINESTRINGM,
>         POLYGONM, MULTIPOLYGONM,
>         CIRCULARSTRINGM, COMPOUNDCURVEM, MULTICURVEM
>         CURVEPOLYGONM, MULTISURFACEM,
>         or GEOMETRYCOLLECTIONM
> CONTEXT:  SQL statement "SELECT AddGeometryColumn('',$1,$2,$3,$4,$5,$6)"
> fonction PL/pgsql « addgeometrycolumn », ligne 4 à instruction SQL

New description:

 Once I've created a shapefile with dxf2shp module, I tried to use the
 module : shapefile to postis, but i got :

 The database gave an error while executing this SQL:
 {{{
 SELECT AddGeometryColumn('public','test1','the_geom',-1,'NULL',2)
 The error was:
 ERREUR:  Invalid type name - valid ones are:
         POINT, MULTIPOINT,
         LINESTRING, MULTILINESTRING,
         POLYGON, MULTIPOLYGON,
         CIRCULARSTRING, COMPOUNDCURVE, MULTICURVE,
         CURVEPOLYGON, MULTISURFACE,
         GEOMETRY, GEOMETRYCOLLECTION,
         POINTM, MULTIPOINTM,
         LINESTRINGM, MULTILINESTRINGM,
         POLYGONM, MULTIPOLYGONM,
         CIRCULARSTRINGM, COMPOUNDCURVEM, MULTICURVEM
         CURVEPOLYGONM, MULTISURFACEM,
         or GEOMETRYCOLLECTIONM
 CONTEXT:  SQL statement "SELECT AddGeometryColumn('',$1,$2,$3,$4,$5,$6)"
 fonction PL/pgsql « addgeometrycolumn », ligne 4 à instruction SQL
 }}}

 Using r15530.

--

-- 
Ticket URL: <https://trac.osgeo.org/qgis/ticket/3641#comment:1>
Quantum GIS <http://qgis.org>
Quantum GIS is an Open Source GIS viewer/editor supporting OGR, PostGIS, and GRASS formats