[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
Resolution:            |   Keywords:
-----------------------+---------------------------
Comment (by strk):

 I just realized it isn't on upgrade that we can fix the sequence as
 there's no extension upgrade being performed, it's just a restore from a
 dump. And we cannot fix anything upon creating the extension either
 because at that time the topology.topology table would be empty. The only
 way to fix a restore from old dump would be to have an "after-restore-
 hook" of some kind, or manual intervention by DBA.

 It could maybe be the CreateTopology function itself looping over sequence
 values until it finds a good fit, if we want it to be easier for users.
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5344#comment:6>
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.