<span>Boa Noite<br><br>No Qgis ao importar uma shp para PGsql dá-me o seguinte erro:<br><br></span><span style="font-family:'Courier New,courier'">Problema inserindo feições do arquivo:</span>
<pre style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px"><span style="font-family:'Courier New,courier'">C:/Users/Utilizador/Dropbox/A2463 Sandra/layers/Equipamentos  Sociais/EQUIPAMENTOS_sociais_dwg_Point.shp</span></pre>



<pre style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px"><span style="font-family:'Courier New,courier'">Ocorreu um erro no banco de dados ao executar este SQL:</span></pre>
<pre style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px"><span style="font-family:'Courier New,courier'">SELECT AddGeometryColumn('public','EQUIPAMENTOS_sociais_dwg_Point','the_geom',-1,'NULL',2)</span></pre>


<pre style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px"><span style="font-family:'Courier New,courier'">O erro foi:</span></pre>
<pre style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px"><span style="font-family:'Courier New,courier'">ERRO:  Invalid type name - valid ones are:</span></pre>
<pre style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px"><span style="font-family:'Courier New,courier'"> POINT, MULTIPOINT,</span></pre>
<pre style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px"><span style="font-family:'Courier New,courier'"> LINESTRING, MULTILINESTRING,</span></pre>
<pre style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px"><span style="font-family:'Courier New,courier'"> POLYGON, MULTIPOLYGON,</span></pre>
<pre style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px"><span style="font-family:'Courier New,courier'"> CIRCULARSTRING, COMPOUNDCURVE, MULTICURVE,</span></pre>
<pre style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px"><span style="font-family:'Courier New,courier'"> CURVEPOLYGON, MULTISURFACE,</span></pre>
<pre style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px"><span style="font-family:'Courier New,courier'"> GEOMETRY, GEOMETRYCOLLECTION,</span></pre>
<pre style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px"><span style="font-family:'Courier New,courier'"> POINTM, MULTIPOINTM,</span></pre>
<pre style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px"><span style="font-family:'Courier New,courier'"> LINESTRINGM, MULTILINESTRINGM,</span></pre>
<pre style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px"><span style="font-family:'Courier New,courier'"> POLYGONM, MULTIPOLYGONM,</span></pre>
<pre style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px"><span style="font-family:'Courier New,courier'"> CIRCULARSTRINGM, COMPOUNDCURVEM, MULTICURVEM</span></pre>
<pre style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px"><span style="font-family:'Courier New,courier'"> CURVEPOLYGONM, MULTISURFACEM,</span></pre>
<pre style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px"><span style="font-family:'Courier New,courier'"> or GEOMETRYCOLLECTIONM</span></pre>
<pre style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px"><span style="font-family:'Courier New,courier'">CONTEXT:  SQL statement "SELECT AddGeometryColumn('', $1 , $2 , $3 , $4 , $5 , $6 )"</span></pre>


<pre style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px"><span style="font-family:'Courier New,courier'">função PL/pgSQL "addgeometrycolumn" linha 5 em comando SQL</span></pre>


<pre style="margin-top:0px;margin-bottom:12px;margin-left:0px;margin-right:0px;text-indent:0px;font-family:'Courier New,courier'"><br>Alguem me consegue dizer que erro é este e como solucionar?<br><br>Cumprimentos,<br>
Sandra<br></pre><br>