[postgis-users] Creating a boundary of an aggregate of buildings

[Tomas Straupis]

2021-01-28, kt, 17:35 Luca Bertoncello rašė:
> I get the error:
>
> FEHLER:  Geometry type (Polygon) does not match column type
> (MultiPolygon)
>
> Could you say me how to correct the query?

  Add ST_Multi like this:

  UPDATE city_boundaries SET way =
ST_Multi(ST_SimplifyPreserveTopology(way, 100));