[QGIS-pt] Postgis: alterar coluna de polygon para multipolygon

[Fred Lehodey]

Mais rápido:
- fazer o alter para type geometry
- fazer o update com st_multi
- fazer novo alter para geometry(multipolygon)

Fred


2014-06-23 17:56 GMT+01:00 Fred Lehodey <lehodey at gmail.com>:

> Olá,
> - pode adicionar uma coluna geom_temp de type multipolygon
> - update geoffreo set geom_temp= st_multi( thegeom_ffr)
> - drop thegeom_ffr
> - rename geom_temp to thegeom_ffr
>
> Abr.
>
>
> On Mon, Jun 23, 2014 at 5:44 PM, Pedro <pedro.ferro at gmail.com> wrote:
>
>> Viva,
>>
>> Tenho uma coluna que está como poligono e preciso de alterá-la para
>> multipoligono.
>> Pensava que seria assim:
>> /alter table geoffreo alter column "thegeom_ffreo" type
>> geometry(MultiPolygon);/
>>
>> mas dá-me o erro:
>> /ERROR:  Geometry type (Polygon) does not match column type
>> (MultiPolygon)/
>>
>> sabem como devo fazê-lo?
>>
>> obrigado,
>> Pedro
>>
>>
>>
>> --
>> View this message in context:
>> http://osgeo-org.1560.x6.nabble.com/Postgis-alterar-coluna-de-polygon-para-multipolygon-tp5147362.html
>> Sent from the QGIS-pt mailing list archive at Nabble.com.
>> _______________________________________________
>> QGIS-pt mailing list
>> QGIS-pt at lists.osgeo.org
>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/qgis-pt
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-pt/attachments/20140623/b96df351/attachment-0001.html>