Opened 15 months ago

Closed 15 months ago

#5526 closed defect (fixed)

ERROR: cannot drop function totopogeom(geometry,character varying,integer,double precision) because other objects depend on it

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

Description

Upgrading in presence of a view using topology.toTopoGeom errors out: 

ERROR:  cannot drop function totopogeom(geometry,character varying,integer,double precision) because other objects depend on it
DETAIL:  view postgis_upgrade_test_data.locking_view depends on function totopogeom(geometry,character varying,integer,double precision)

See ​https://woodie.osgeo.org/repos/30/pipeline/959/7#L7435

This was already fixed in master branch with [5599ab1518b1d406fa82e74d769f0c4916b53aeb/git] so this ticket is to backport it (if we see it worth) to 3.4 branch.

It doesn't seem to make much sense defining views using volatile functions but you never know what arbitrary users can do, and if anyone does it it's not nice to block the upgrade maybe ?

Change History (1)

comment:1 by strk, 15 months ago

Resolution: → fixed
Status: new → closed

Referenced by [5599ab1518b1d406fa82e74d769f0c4916b53aeb/git] in master branch (3.5.0dev)

Closed by [e428b70577bd51d3924346d9f0124a6d37ef4ff8/git] in 3.4 branch (3.4.1dev)

Note: See TracTickets for help on using tickets.