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. _______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
