[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 robe):

 Replying to [comment:18 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.


 @rama.  The SELECT postgis_extensions_upgrade() does not touch pgrouting.
 So to fix those.

 Try first doing, the below, it may not work because the pgrouting
 pgr_drivingdistance has undergone quite a few changes over the years, so
 sadly a drop your materialized view and rebuild after you run ALTER
 EXTENSION pgrouting UPDATE or DROP and create extension pgrouting might be
 your only options.

 ```
 ALTER EXTENSION pgrouting UPDATE;
 ```
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5584#comment:19>
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.