[postgis-tickets] [PostGIS] #5115: Deferred constraint prevents dropping topology

[PostGIS]

#5115: Deferred constraint prevents dropping topology
-----------------------+---------------------------
  Reporter:  ccrook    |      Owner:  strk
      Type:  defect    |     Status:  assigned
  Priority:  medium    |  Milestone:  PostGIS 3.3.0
 Component:  topology  |    Version:  3.2.x
Resolution:            |   Keywords:
-----------------------+---------------------------
Changes (by strk):

 * status:  new => assigned


Comment:

 Issue confirmed. The issue is present also in PostGIS-3.0 (and probably
 earlier too).
 Work in progress fix is here:
 https://gitlab.com/postgis/postgis/-/merge_requests/73

 Those pending constraints need to be executed in order for the drop to be
 accepted.
 You can force executing them with this:

   SET constraints ALL IMMEDIATE;

 Or, to be stricter:

   SET constraints mytopology.next_right_edge_exists,
 mytopology.next_left_edge_exists IMMEDIATE;

 To be honest I forgot why we're making those constraints deferred, it may
 have been a bad choice

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