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

 Please keep the ticket open I will close the ticket once my production
 upgrade is over

 I have come across couple more issue could please help me to fix the same

 while Upgrading Extension [SELECT postgis_extensions_upgrade();]
 {{{

 Issue 1: Some Extension function is owned by the user and the extension is
 owned by Postgres. Should we change ownership of function postgres or we
 have to run extension upgrade from the user.

 ERROR:  Function postgis_noop(raster) is owned by xyz but extension is
 owned by postgres

 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:17>
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.