<div dir="ltr"><span style="font-family:arial,sans-serif;font-size:13px">Mais rápido:</span><div style="font-family:arial,sans-serif;font-size:13px">- fazer o alter para type geometry</div><div style="font-family:arial,sans-serif;font-size:13px">
- fazer o update com st_multi</div><div style="font-family:arial,sans-serif;font-size:13px">- fazer novo alter para geometry(multipolygon)</div><div style="font-family:arial,sans-serif;font-size:13px"><br></div><div style="font-family:arial,sans-serif;font-size:13px">
Fred</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">2014-06-23 17:56 GMT+01:00 Fred Lehodey <span dir="ltr"><<a href="mailto:lehodey@gmail.com" target="_blank">lehodey@gmail.com</a>></span>:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Olá,<div>- pode adicionar uma coluna geom_temp de type multipolygon</div><div>- update <span style="font-family:arial,sans-serif;font-size:13px">geoffreo</span><span style="font-family:arial,sans-serif;font-size:13px"> set geom_temp= st_multi(</span> <span style="font-size:13px;font-family:arial,sans-serif">thegeom_ffr)</span></div>

<div><span style="font-size:13px;font-family:arial,sans-serif">- drop </span><span style="font-family:arial,sans-serif;font-size:13px">thegeom_ffr</span></div><div><span style="font-family:arial,sans-serif;font-size:13px">- rename geom_temp to </span><span style="font-family:arial,sans-serif;font-size:13px">thegeom_ffr</span></div>

<div><br></div><div><span style="font-family:arial,sans-serif;font-size:13px">Abr.</span></div></div><div class="HOEnZb"><div class="h5"><div class="gmail_extra"><br><br><div class="gmail_quote">On Mon, Jun 23, 2014 at 5:44 PM, Pedro <span dir="ltr"><<a href="mailto:pedro.ferro@gmail.com" target="_blank">pedro.ferro@gmail.com</a>></span> wrote:<br>

<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Viva,<br>
<br>
Tenho uma coluna que está como poligono e preciso de alterá-la para<br>
multipoligono.<br>
Pensava que seria assim:<br>
/alter table geoffreo alter column "thegeom_ffreo" type<br>
geometry(MultiPolygon);/<br>
<br>
mas dá-me o erro:<br>
/ERROR:  Geometry type (Polygon) does not match column type (MultiPolygon)/<br>
<br>
sabem como devo fazê-lo?<br>
<br>
obrigado,<br>
Pedro<br>
<br>
<br>
<br>
--<br>
View this message in context: <a href="http://osgeo-org.1560.x6.nabble.com/Postgis-alterar-coluna-de-polygon-para-multipolygon-tp5147362.html" target="_blank">http://osgeo-org.1560.x6.nabble.com/Postgis-alterar-coluna-de-polygon-para-multipolygon-tp5147362.html</a><br>


Sent from the QGIS-pt mailing list archive at Nabble.com.<br>
_______________________________________________<br>
QGIS-pt mailing list<br>
<a href="mailto:QGIS-pt@lists.osgeo.org" target="_blank">QGIS-pt@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/qgis-pt" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/qgis-pt</a><br>
</blockquote></div><br></div>
</div></div></blockquote></div><br></div>