[PostGIS] #5584: PostGIS Upgrade Issue

[PostGIS]

#5584: PostGIS Upgrade Issue
---------------------------+-------------------------------
  Reporter:  rama          |      Owner:  strk
      Type:  defect        |     Status:  new
  Priority:  critical      |  Milestone:  PostGIS Packaging
 Component:  upgrade/soft  |    Version:  3.3.x
Resolution:                |   Keywords:  windows
---------------------------+-------------------------------
Comment (by rama):

 @strk

 Could you please Provide suggestion for user dependent objects for
 pgrouting and postgis_sfcgal

 Some of our database have user object depency please provide solution for
 the same

 Issue 2:  While Dropping and creating extension pgrouting i am getting
 some views are depend on it. Should I take  backup and delete the view
 before upgrading and recreate after it? Or do we have some other option?

 ERROR:  cannot drop extension pgrouting because other objects depend on it
 DETAIL:  materialized view o17_transportation.isochrone_nodes_walk depends
 on function pgr_drivingdistance(text,bigint,double
 precision,boolean,boolean)
 materialized view o17_transportation.isochrone_edges_walk depends on
 materialized view o17_transportation.isochrone_nodes_walk
 HINT:  Use DROP ... CASCADE to drop the dependent objects too.
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5584#comment:18>
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.