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

PostGIS trac at osgeo.org
Mon Aug 28 01:35:43 PDT 2023


#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
 Keywords:                         |
-----------------------------------+---------------------------
 =# 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>
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.


More information about the postgis-tickets mailing list