[PostGIS] #6017: copytopology creates blank feature_column sometimes

[PostGIS]

#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
 Keywords:            |
----------------------+---------------------------
 While testing the topogeometry corruption and putting in hooks
 before/after.
 I noticed that the copytopology test is failing, but hooks don't tell me
 that.

 Anyway I also confirmed this issue has nothing to do with the support for
 bigint as the same issue exists in 3.5.5dev.  I haven't confirmed older
 versions.

 To replicate run the hook tests we have without upgrading.

 I'll add the test to 3.7 after I've figured out what's up with woodie.

 {{{
 CREATE EXTENSION postgis VERSION "3.5.5dev";
 CREATE EXTENSION postgis_topology VERSION "3.5.5dev";
 SELECT topology.createTopology('upgrade_test');

 -- Create some TopoGeometry data
 CREATE TABLE upgrade_test.feature(id serial primary key);
 SELECT topology.AddTopoGeometryColumn('upgrade_test', 'upgrade_test',
 'feature', 'tg', 'linear');
 INSERT INTO upgrade_test.feature(tg) SELECT
 topology.toTopoGeom('LINESTRING(0 0, 10 0)', 'upgrade_test', 1);
 CREATE INDEX ON upgrade_test.feature ( id(tg) );

 -- Create some TopoGeometry data
 CREATE TABLE upgrade_test.domain_test(a topology.topoelement, b
 topology.topoelementarray);
 INSERT INTO upgrade_test.domain_test values (
   '{1,2}'::topology.topoelement,
   '{{2,3}}'::topology.topoelementarray
 );

 SELECT * FROM topology.layer;

 SELECT topology.CopyTopology('upgrade_test', 'upgrade_test_copy');

 SELECT * FROM topology.layer;
 }}}


 output is:


 {{{
 createtopology
 ----------------
               1
 (1 row)


  addtopogeometrycolumn
 -----------------------
                      1
 (1 row)


 INSERT 0 1
 CREATE INDEX
  topology_id | layer_id | schema_name  | table_name | feature_column |
 feature_type | level | child_id
 -------------+----------+--------------+------------+----------------+--------------+-------+----------
            1 |        1 | upgrade_test | feature    | tg             |
 2 |     0 |
 (1 row)

  copytopology
 --------------
             2
 (1 row)


  topology_id | layer_id |    schema_name    | table_name | feature_column
 | feature_type | level | child_id
 -------------+----------+-------------------+------------+----------------+--------------+-------+----------
            1 |        1 | upgrade_test      | feature    | tg
 |            2 |     0 |
            2 |        1 | upgrade_test_copy | LAYER1     |
 |            2 |     0 |
 (2 rows)

 }}}
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/6017>
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.