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

[Pietro Rossin]

Hello
I'm trying to copy polygons from one column to another to reduce vertex
numbers

my columns are geom (geom geometry(MultiPolygonZ,3004))
and geom_simply (geom_simply geometry(MultiPolygonZ,3004))
With this query
UPDATE mytable
   SET geom_simply=ST_SimplifyPreserveTopology(geom, 100)
I get this error:
ERROR: Geometry type (Polygon) does not match column type (MultiPolygon)
SQL state: 22023

Also this query return error:

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?
I know there are few multipolygon in the geom column..
Thanks
Pietro




--
View this message in context: http://postgis.17.x6.nabble.com/error-on-copying-geometries-between-geometry-columns-tp5003977.html
Sent from the PostGIS - User mailing list archive at Nabble.com.