Opened 4 years ago

Last modified 2 years ago

#4682 new task

Turn topology.topology and topology.layer into views

Reported by: strk Owned by: strk
Priority: medium Milestone: PostGIS Fund Me
Component: topology Version: master
Keywords: usability Cc:

Description

It would be helpful to move the data of topology.topology and topology.layer into views, for easy of portability, and to safely respect view permissions on existance of tables (See #4575).

At the moment the TopoGeometry values do contain references to topology identifier and layer identifier, both of which are numeric and require some centralized support for assignment. It has to be defined how these identifiers should be dealth with, in terms of validity across databases.

Change History (3)

comment:1 by Algunenano, 4 years ago

Milestone: PostGIS Fund Me

comment:2 by strk, 3 years ago

Another good reason to implement this: ability to have views listed in the topology.layer relation (although we'd have to decide how to represent which relation is the "official" relation containing TopoGeometries, because we do have the concept of "orphaned topogeometries" when the "official" relation [deploy target] doesn't contain topogeometry objects known by the "relation" table)

comment:3 by strk, 2 years ago

Keywords: usability added
Note: See TracTickets for help on using tickets.