[postgis-tickets] [PostGIS] #5106: ST_RemEdgeNewFace causes postgre to core dump, but not ST_RemEdgeModFace

[PostGIS]

#5106: ST_RemEdgeNewFace causes postgre to core dump, but not ST_RemEdgeModFace
-----------------------+---------------------------
  Reporter:  laopsahl  |      Owner:  strk
      Type:  defect    |     Status:  new
  Priority:  medium    |  Milestone:  PostGIS 3.4.0
 Component:  topology  |    Version:  3.2.x
Resolution:            |   Keywords:
-----------------------+---------------------------
Comment (by strk):

 I'm able to reproduce the crash but only by dropping the foreign key
 constraints:
 {{{
 BEGIN;

 SELECT topology.CreateTopology('t5106');

 INSERT INTO t5106.node VALUES
 ( 1, NULL, 'POINT(0 0)'::geometry ),
 ( 2, NULL, 'POINT(10 10)'::geometry );

 ALTER TABLE t5106.edge_data DROP constraint left_face_exists;
 ALTER TABLE t5106.edge_data DROP constraint right_face_exists;

 INSERT INTO t5106.edge VALUES
 (
   1, -- edge_id
   1, 2, -- start/end node
   2, -2, -- next left/right edge
   1, 2, -- left/right faces (non existent)
   'LINESTRING(0 0,10 0,10 10)'::geometry
 ),
 (
   2, -- edge_id
   2, 1, -- start/end node
   1, -1, -- next left/right edge
   1, 2, -- left/right faces (non existent)
   'LINESTRING(10 10,0 10,0 0)'::geometry
 );

 SELECT ST_RemEdgeModFace('t5106', 1);
 }}}

 If I don't drop the left_face_exists and right_face_exists foreign key
 constraints I cannot create the offending situation
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5106#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.