[postgis-tickets] [PostGIS] #5526: ERROR: cannot drop function totopogeom(geometry, character varying, integer, double precision) because other objects depend on it

[PostGIS]

#5526: ERROR:  cannot drop function totopogeom(geometry,character
varying,integer,double precision) because other objects depend on it
----------------------+---------------------------
 Reporter:  strk      |      Owner:  strk
     Type:  defect    |     Status:  new
 Priority:  medium    |  Milestone:  PostGIS 3.4.1
Component:  topology  |    Version:  3.4.x
 Keywords:            |
----------------------+---------------------------
 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 ?
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5526>
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.