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

PostGIS trac at osgeo.org
Sun Feb 19 17:04:59 PST 2023


#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):

 Figured: we DO re-run pg_extension_config_dump multiple times, so upgrades
 are ok. My only problem was that run_test.pl is only upgrading AFTER
 dumping the source DB, thus failing to recover the sequence in an
 appropriate way. The only way to support in some automatic way the restore
 of dumps from pre-fix versions would be to re-set the sequence in the
 upgrade script ALWAYS, after looking at the max value of the topology.id.
 Would youf ind that too invasive Regina ?
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5344#comment:3>
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