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

[Paolo Cavallini]

-----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-----