Opened 5 years ago

Closed 5 years ago

#4488 closed defect (fixed)

pg_restore: ERROR: relation "topology_id_seq" already exists

Reported by: strk Owned by: strk
Priority: blocker Milestone: PostGIS 3.0.0
Component: topology Version: master
Keywords: Cc:


Spotted in

… it looks like we're not properly marking a sequence as being part of the extension …

Probably since forever.

Change History (8)

comment:1 by strk, 5 years ago

#2503 may be related to this

comment:2 by strk, 5 years ago

To reproduce:

cd topology/test
../../regress/ --topology -v --dumprestore --extension \
     --upgrade-path unpackaged--3.0.0alpha5dev \

comment:3 by strk, 5 years ago

The comments above the target rule for sql/topology_upgrade.sql in extensions/postgis_topology/ say they are supposed to do many things which aren't really done, like removing the CREATE TABLE parts

comment:4 by strk, 5 years ago

I see there's no config_dump call in either postgis/sql/postgis—unpackaged—3.0.0alpha5dev.sql or postgis_topology/sql/postgis_topology—unpackaged—3.0.0alpha5dev.sql so this might be a problem for core as well ?

comment:5 by strk, 5 years ago

In 17759:

Add support for extension sequences in

Should fix topology dump-restore
References #4488

comment:6 by strk, 5 years ago

I think this is fixed with r17759 (improved Will wait for confirmation by gitlab-ci though

comment:8 by strk, 5 years ago

Resolution: fixed
Status: newclosed

Gitlab-CI confirms, yay!

Note: See TracTickets for help on using tickets.