[postgis-tickets] [PostGIS] #3507: topology.relation trigger guard insert/update but no delete

[PostGIS]

#3507: topology.relation trigger guard insert/update but no delete
---------------------+---------------------------
 Reporter:  strk     |      Owner:  pramsey
     Type:  defect   |     Status:  new
 Priority:  medium   |  Milestone:  PostGIS 2.3.0
Component:  postgis  |    Version:  2.0.x
 Keywords:           |
---------------------+---------------------------
 Deleting records from topology "relation" table can break the definition
 of hierarchical TopoGeometry objects but such broken dataset cannot be
 copied into a new "relation" table. This becomes clear on CopyTopology,
 which fails when it finds such "broken" tables.

 I guess the fix here would be to have the "relation_integrity_checks"
 trigger also run before DELETE.

--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/3507>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.