[postgis-tickets] [PostGIS] #5344: Restoring extension based topology dump fails resetting the topology sequence
PostGIS
trac at osgeo.org
Sun Feb 19 20:34:12 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 robe):
Replying to [comment:3 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 ?
No I wouldn't
--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5344#comment:5>
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