ST_ChangeEdgeGeom — Changes the shape of an edge without affecting the topology structure.
integer ST_ChangeEdgeGeom(varchar atopology, integer anedge, geometry acurve
Changes the shape of an edge without affecting the topology structure.
If any arguments are null, the given edge does not exist in
edge table of the topology schema, the
acurve is not a
LINESTRING, or the modification would
change the underlying topology then an error is thrown.
If the spatial reference system (srid) of the
acurve geometry is not the same as the topology an exception is thrown.
If the new
acurve is not simple, then an error is thrown.
If moving the edge from old to new position would hit an obstacle then an error is thrown.
Enhanced: 2.0.0 adds topological consistency enforcement
This method implements the SQL/MM specification. SQL-MM: Topo-Geo and Topo-Net 3: Routine Details X.3.6
SELECT topology.ST_ChangeEdgeGeom('ma_topo', 1, ST_GeomFromText('LINESTRING(227591.9 893900.4,227622.6 893844.3,227641.6 893816.6, 227704.5 893778.5)', 26986) ); ---- Edge 1 changed