Bug report #2043
Merging multi-polygon-features on PostGIS fails
|Affected QGIS version:||Regression?:||No|
|Operating System:||Debian||Easy fix?:||No|
|Pull Request or Patch supplied:||Resolution:||fixed|
|Crashes QGIS or corrupts data:||Copied to github as #:||12103|
QGIS 1.3.0 can't merge features as described below:
"The union operation would result in a geometry type that is not compatible with the current layer and therefore is canceled"
Imagine a PostGIS-geometry-table, using the type multipolygon. Some of the features therein have islands, others don't. If you try to merge two features without islands, the resulting feature is type polygon. This also happens, when you try it manually using st_union. Since there is a constraint on the geometry column, the resulting feature can't be inserted. Using st_multi helps on database level.
PostGIS-Version is 1.3.6.