#5577 closed defect (fixed)

restoring dump from 3.1: ERROR: function "addnode" already exists with same argument types

Reported by: strk Owned by: strk
Priority: medium Milestone: PostGIS 3.4.1
Component: build Version: 3.4.x
Keywords: Cc:

Description

regress/run_test.pl --raster --topology --dumprestore --upgrade-path unpackaged3.1--:auto regress/core/regress -v
...
ERROR:  function "addnode" already exists with same argument types

Change History (3)

comment:1 by strk, 13 months ago

Signature in dump:

FUNCTION topology addnode(character varying, public.geometry)

Signature in skip list (generated):

FUNCTION addnode(character varying, geometry, boolean, boolean)

The old signature is removed by a _postgis_drop_function_by_signature call in topology/topology_before_upgrade.sql.in but with a multi-line approach, which may be confusing the skip-list generator script

comment:2 by Sandro Santilli <strk@…>, 13 months ago

In cc16070/git:

Fix restore of dumps with topology from 3.1

References #5577 in master branch (3.5.0dev)

comment:3 by Sandro Santilli <strk@…>, 13 months ago

Resolution: fixed
Status: newclosed

In 9c44d61/git:

Fix restore of dumps with topology from 3.1

Closes #5577 in 3.4 branch (3.4.1dev)

Note: See TracTickets for help on using tickets.