I have a point layer that I create points in first. Then I have a line layer that I create a route that snaps to each of these points using the add feature tool. When I commit to the database, I have a trigger function that creates a second line layer that by slicing the route at each of the points and stores those segments.
(The points are utility poles, the first line layer is a fiber route, and the second line layer is for creating a CAD like dimensional drawing of the distance between the poles)
In my trigger function, I use st_intersects() and it works beautifully whenever a route segment is touching at least one point that was snapped to during initial digitizing but it ignores any new points.
However, if I move a route segment around such that it is touching new poles but not ones that it was snapped to during digitizing, the segments in the second layer do not get regenerated.
Based on my testing, I suspect that the snapping accuracy between digitizing and moving a node using the node tool are different and st_intersect has an really tight tolerance.
Any idea's on how to solve my dilemma?