[postgis-tickets] [PostGIS] #5484: ERROR: cannot drop function st_value(raster, geometry, boolean) because other objects depend on it

[PostGIS]

#5484: ERROR:  cannot drop function st_value(raster,geometry,boolean) because
other objects depend on it
------------------------------------+---------------------------
  Reporter:  strk                   |      Owner:  strk
      Type:  defect                 |     Status:  new
  Priority:  medium                 |  Milestone:  PostGIS 3.4.1
 Component:  build/upgrade/install  |    Version:  3.4.x
Resolution:                         |   Keywords:
------------------------------------+---------------------------
Description changed by strk:

Old description:

> =# select postgis_extensions_upgrade();
> NOTICE:  Updating extension postgis from 3.1.1 to 3.4.0
> NOTICE:  Extension postgis_sfcgal is not available or not packagable for
> some reason
> NOTICE:  Updating extension postgis_raster from 3.1.1 to 3.4.0
> ERROR:  cannot drop function st_value(raster,geometry,boolean) because
> other objects depend on it
> DETAIL:  view helmer_tmp.tracking_hr_with_rst_v depends on function
> st_value(raster,geometry,boolean)
> HINT:  Use DROP ... CASCADE to drop the dependent objects too.
> CONTEXT:  SQL statement "ALTER EXTENSION postgis_raster UPDATE TO
> "3.4.0";"
> PL/pgSQL function postgis_extensions_upgrade() line 79 at EXECUTE

New description:

 {{{
 =# select postgis_extensions_upgrade();
 NOTICE:  Updating extension postgis from 3.1.1 to 3.4.0
 NOTICE:  Extension postgis_sfcgal is not available or not packagable for
 some reason
 NOTICE:  Updating extension postgis_raster from 3.1.1 to 3.4.0
 ERROR:  cannot drop function st_value(raster,geometry,boolean) because
 other objects depend on it
 DETAIL:  view helmer_tmp.tracking_hr_with_rst_v depends on function
 st_value(raster,geometry,boolean)
 HINT:  Use DROP ... CASCADE to drop the dependent objects too.
 CONTEXT:  SQL statement "ALTER EXTENSION postgis_raster UPDATE TO
 "3.4.0";"
 PL/pgSQL function postgis_extensions_upgrade() line 79 at EXECUTE
 }}}

--
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5484#comment:1>
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.