The following bug has been logged on the website:
Bug reference: 13482
Logged by: Satish Rajesh
Email address: mailrsatish(at)gmail(dot)com
PostgreSQL version: 9.4.0
Operating system: Ubuntu
Description:
Hi,
I am trying to the datatype to MultiPolygon but getting the below error due
other geometry type available in the table,
DDL Statement
-----------------
ALTER TABLE output.addresspoi_test ALTER COLUMN geom SET DATA TYPE
geometry(MultiPolygon) USING ST_Multi(geom);
ERROR: Geometry type (MultiSurface) does not match column type
(MultiPolygon)
geometrytype | count
--------------+---------
MULTIPOLYGON | 3541837
MULTISURFACE | 37
(2 rows)
Regards,
Satish Rajesh