[postgis-tickets] [PostGIS] #5344: Restoring extension based topology dump fails resetting the topology sequence

[PostGIS]

#5344: Restoring extension based topology dump fails resetting the topology
sequence
----------------------+---------------------------
 Reporter:  strk      |      Owner:  strk
     Type:  defect    |     Status:  new
 Priority:  medium    |  Milestone:  PostGIS 3.4.0
Component:  topology  |    Version:  master
 Keywords:            |
----------------------+---------------------------
 Restored dump of database with extension-based topology and a topology
 fails to restore the topology sequence, so that next invocation of
 CreateTopology finds duplicated key.

 To reproduce:

 {{{
 touch empty.sql empty_expected
 regress/run_test.pl -v \
    --dumprestore --upgrade \
    --topology --extension \
    --before-upgrade-script topology/test/regress/hooks/hook-before-
 upgrade-topology.sql \
    --after-upgrade-script topology/test/regress/hooks/hook-after-upgrade-
 topology.sql \
     empty
 }}}

 Caught by CI here:
 https://gitlab.com/postgis/postgis/-/jobs/3797640891#L5292
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5344>
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.