[PostGIS] #5848: expose a lower level function of TopoGeo_AddLineString that returns more info

PostGIS trac at osgeo.org
Tue Feb 4 00:35:48 PST 2025


#5848: expose a lower level function of TopoGeo_AddLineString that returns more
info
--------------------------------+---------------------------
  Reporter:  Lars Aksel Opsahl  |      Owner:  strk
      Type:  enhancement        |     Status:  new
  Priority:  medium             |  Milestone:  PostGIS 3.5.3
 Component:  topology           |    Version:  3.4.x
Resolution:                     |   Keywords:
--------------------------------+---------------------------
Comment (by strk):

 The reason why those functions automatically update the TopoGeometry
 objects definition is specifically to allow you to "track" that
 information. By saving a TopoGeometry, rather than the "edge identifier"
 you will be able to query its composition and automatically find which
 edges it is composed by at any time.

 What you might be missing is a notification of WHEN the TopoGeometry
 object you are holding changes composition. Note that the composition of
 that object might be changed also from a different transaction than the
 one in your session.

 Every now and then I think that we could be using the asynchronous
 notifications support, to let various listeners know when the definition
 of a TopoGeometry changes ( https://www.postgresql.org/docs/current/sql-
 notify.html )

 That need of being notified may serve other purposes like think triggers
 on the table holding TopoGeometry. The literal value of a TopoGeometry -
 for example: '(1,2,3,4)' - never changes, but the actual composition
 (stored in the topology relation table) can very well change and the only
 option at the moment to know when something happens is by adding user
 triggers to the relation table.

 What I'm afraid of is that even if you have a function that tells you what
 happened to the topology edges you'll still be missing some events. For
 this maybe a trigger on the relation table is even better than a
 listen/notify system.
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5848#comment:2>
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