[postgis-tickets] [PostGIS] #5488: Upgrade from 3.1.1: ERROR: cannot drop function st_clip(raster, integer, geometry, double precision, boolean) because other objects depend on it

[PostGIS]

#5488: Upgrade from 3.1.1: ERROR:  cannot drop function
st_clip(raster,integer,geometry,double precision,boolean) because other
objects depend on it
------------------------------------+------------------
  Reporter:  strk                   |      Owner:  strk
      Type:  defect                 |     Status:  new
  Priority:  medium                 |  Milestone:
 Component:  build/upgrade/install  |    Version:
Resolution:                         |   Keywords:
------------------------------------+------------------
Comment (by strk):

 The current definition of that function in raster/rt_pg/rtpostgis.sql.in
 is:
 {{{
 CREATE OR REPLACE FUNCTION st_clip(
   rast raster, nband integer,
   geom geometry,
   nodataval double precision, crop boolean DEFAULT TRUE
 )
 }}}

 The rtpostgis_upgrade_cleanup.sql.in file drops all of these:
 {{{
 DROP FUNCTION IF EXISTS st_clip(raster, integer, geometry, boolean);
 DROP FUNCTION IF EXISTS st_clip(raster, geometry, float8, boolean);
 DROP FUNCTION IF EXISTS st_clip(raster, geometry, boolean);
 DROP FUNCTION IF EXISTS st_clip(raster, int, geometry, float8, boolean);
 DROP FUNCTION IF EXISTS st_clip(raster, geometry, float8[], boolean);
 DROP FUNCTION IF EXISTS st_clip(raster, integer, geometry, float8[],
 boolean);
 }}}

 Saying, in a comment, that their signature changed (the comment does not
 say when and how)
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5488#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.