Opened 8 months ago
Closed 8 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 ?
Note:
See TracTickets
for help on using tickets.
Referenced by [5599ab1518b1d406fa82e74d769f0c4916b53aeb/git] in master branch (3.5.0dev)
Closed by [e428b70577bd51d3924346d9f0124a6d37ef4ff8/git] in 3.4 branch (3.4.1dev)