I'm using MapInfo 16 to edit a PostGIS table through ODBC driver.
The geometry column type of my table is
The value in
spatialtype colmun of a record in
mapinfo.mapinfo_mapcatalog table is
19.2. That stands for MapInfo
region type AFAIK.
When I'm hitting a
Save Table button, I get an ODBC Error:
Geometry type (Polygon) does not match column type (MultiPolygon);
So I guess MapInfo is trying to insert a Polygon geometry into a MultiPolygon column. Converting new created features to regions doesn't help.
The only workaround I can think of is to set a
BEFORE INSERT trigger on this table with something like
NEW.geom := st_multi(NEW.geom);
But it doesn't seem like a natural solution.
Maybe I'm missing something in MapInfo options?
UPDATE:Proposed trigger solution doesn't work. Seems like type checking happens earlier than trigger fires.