[postgis-tickets] [PostGIS] #5106: ST_RemEdgeNewFace causes postgre to core dump, but not ST_RemEdgeModFace
PostGIS
trac at osgeo.org
Mon Jan 30 06:55:11 PST 2023
#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.
More information about the postgis-tickets
mailing list