[postgis-users] error on copying geometries between geometry columns

[Pietro Rossin]

Thanks Paolo
It worked like this:
set geom_simply=ST_Multi(ST_SimplifyPreserveTopology(geom, 100))
Bie
Pietro


2013/8/12 Paolo Cavallini <cavallini at faunalia.it>

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Il 12/08/2013 13:19, Pietro Rossin ha scritto:
>
> > UPDATE mytable SET
> > geom_simply=ST_SimplifyPreserveTopology(st_multi(geom), 100)
> >
> > ERROR: Geometry type (Polygon) does not match column type
> > (MultiPolygon) SQL state: 22023
> >
> > Why?
>
> Try
>     SET
> geom_simply=ST_Multi(ST_SimplifyPreserveTopology(st_multi(geom), 100))
>
> - --
> Paolo Cavallini - Faunalia
> www.faunalia.eu
> Full contact details at www.faunalia.eu/pc
> Nuovi corsi QGIS e PostGIS: http://www.faunalia.it/calendario
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.14 (GNU/Linux)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
>
> iEYEARECAAYFAlIIx1UACgkQ/NedwLUzIr7CfgCgmrjYsZx1VYPv8e1s84xKJ61Q
> wu0An1uGZgFQF5mvhfj98flwerRC3KTj
> =dUaB
> -----END PGP SIGNATURE-----
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130812/90395d78/attachment.html>