I'm using Postgres 9.4 and PostGIS 2.1. I have a table that looks like this:
wkb_geometry | geometry(Polygon,4326) | id | integer | county | character varying |
I've learned that the table contains some invalid polygons (e.g. when I try to do
ST_UNION I get errors), so I'm trying to fix them:
UPDATE mytable SET wkb_geometry=ST_makevalid(wkb_geometry) WHERE id='1';
But this gives me an error:
ERROR: Geometry type (MultiPolygon) does not match column type (Polygon)
What should I do about this?