[PostGIS] #6017: copytopology creates blank feature_column sometimes

PostGIS trac at osgeo.org
Wed Nov 12 22:27:17 PST 2025


#6017: copytopology creates blank feature_column sometimes
-----------------------+---------------------------
  Reporter:  robe      |      Owner:  strk
      Type:  defect    |     Status:  new
  Priority:  medium    |  Milestone:  PostGIS 3.5.5
 Component:  topology  |    Version:  3.5.x
Resolution:            |   Keywords:
-----------------------+---------------------------
Comment (by strk):

 That's actually expected, as CopyTopology does NOT copy the layer data, so
 what you are left with is so-called "DETACHED" layers, as reported by
 TopologySummary:
 {{{
 =# select topologysummary(name) from topology where name =
 'upgrade_test_copy';
                     topologysummary
 --------------------------------------------------------
  Topology upgrade_test_copy (id 3, SRID 0, precision 0)+
  2 nodes, 1 edges, 0 faces, 1 topogeoms in 1 layers    +
  Layer 1, type Lineal (2), 1 topogeoms                 +
   Deploy: NONE (detached)                              +

 (1 row)
 }}}

 Since there's no "deploy" target for those layers (that are known to exist
 as the relation table data IS copied and refers to them) the code write
 arbitrary information in the "schema_name", "table_name" and
 "feature_column" of the newly created layer record; and when I implemented
 that I evidently went with the topology schema as the detached/phantom
 layer's "schema_name", the literal "LAYER#" as the "table_name" and a
 plain NULL as the "feature_column". And one of these values (I guess the
 NULL) is what TopologySummary recognizes as a signe of a "DETACHED" layer.

 I hope this is clear and see #1195 for a past discussion about this
 situation and proposals for improving them.

 But given the above, this ticket should probably be closed as invalid
 (expected). Just make sure it's "always" and not "sometimes' that this
 happen, maybe ?
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/6017#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