[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:16:14 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):

 DROP SEQUENCE IF EXISTS is supported since PostreSQL 8.2 so we could use
 that:
 https://www.postgresql.org/docs/8.2/sql-dropsequence.html

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5118#comment:8>
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