[postgis-tickets] [PostGIS] #5119: Allow COPY to topology edge view

PostGIS trac at osgeo.org
Wed Feb 15 12:30:45 PST 2023


#5119: Allow COPY to topology edge view
--------------------------+---------------------------
  Reporter:  strk         |      Owner:  strk
      Type:  enhancement  |     Status:  new
  Priority:  medium       |  Milestone:  PostGIS 3.4.0
 Component:  topology     |    Version:  master
Resolution:               |   Keywords:  usability
--------------------------+---------------------------
Comment (by pramsey):

 To complete the thought: had I been looking at the original edge table and
 been thinking "I need to add a directionality flag to the right/left face
 information" I'd have just added two booleans to the end of the edge table
 to flag the directionality. very small, additive-only change.

 I think the goal of "hewing to the standard" kind of falls apart when what
 you are adding (the capability to store rings that include a self-
 intersection in the form of a "spike") is a capability the original
 standard didn't anticipate. I imagine if you brought it to the SQL/MM
 folks they'd say "uh, no, you should only have OGC valid rings
 participating in faces". So you're in uncharted waters, change the edge
 table slightly to sail safely through.
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5119#comment:5>
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