[postgis-tickets] [PostGIS] #5118: DropTopology: ERROR: update or delete on table "topology" violates foreign key constraint "layer_topology_id_fkey" on table "layer"
PostGIS
trac at osgeo.org
Mon Mar 28 05:12:36 PDT 2022
#5118: DropTopology: ERROR: update or delete on table "topology" violates foreign
key constraint "layer_topology_id_fkey" on table "layer"
-----------------------+---------------------------
Reporter: strk | Owner: strk
Type: defect | Status: new
Priority: medium | Milestone: PostGIS 3.3.0
Component: topology | Version: 3.2.x
Resolution: | Keywords:
-----------------------+---------------------------
Comment (by strk):
Got it: the NOTICE should probably be an EXCEPTION in that it *prevents*
deleting from topology.layer if records still exist in the relation table:
{{{
xxx=# delete from topology.layer where topology_id = 17 and layer_id = 1;
NOTICE: A record in city_data.relation still references layer 1
DELETE 0
}}}
--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5118#comment:6>
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.
More information about the postgis-tickets
mailing list