I have a table that contains a multipolygon column.
In my application, I use a view on the table which splits the multipolygon in several polygons:
CREATE VIEW myview AS SELECT a.id, ST_SetSRID((st_dump(a.geom)).geom,25832) AS geom FROM mytable a;
I want to declare a rule on that view, that I can perform an update operation on
mytable in order that a newly added polygon gets added to the multipolygon column.
CREATE RULE insert_geom_to_myview AS ON INSERT TO myview DO instead UPDATE mytable set geom = "add_new_polygon_to_multipolygon"