Upgrade from 3.1.1: ERROR: cannot drop function st_slope(raster,integer,text,text,double precision,boolean) because other objects depend on it

[strk]

Another case of upgrade trouble:

=# 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
ERROR:  cannot drop function st_slope(raster,integer,text,text,double precision,boolean) because other objects depend on it

See also #5488

[strk]

Current signatures (2.1.0 to 3.5.0dev aka master):

-- 1
st_slope(
 rast raster,
 nband integer,
 customextent raster,
 pixeltype text DEFAULT '32BF',
 units text DEFAULT 'DEGREES',
 scale double precision DEFAULT 1.0,
 interpolate_nodata boolean DEFAULT FALSE
)

-- 2
st_slope(
 rast raster,
 nband integer DEFAULT 1,
 pixeltype text DEFAULT '32BF',
 units text DEFAULT 'DEGREES',
 scale double precision DEFAULT 1.0,
 interpolate_nodata boolean DEFAULT FALSE
)

In stable-2.0 we have a single signature:

  st_slope(rast raster, band integer, pixeltype text)

[strk]

The other internal function signature is (2.1.0 to master):

_st_slope4ma(value double precision[][][], pos integer[][], VARIADIC userargs text[] DEFAULT NULL)

In 2.0.0 it was instead:

_st_slope4ma(matrix float[][], nodatamode text, variadic args text[])

[strk]

WIP PR: ​https://git.osgeo.org/gitea/postgis/postgis/pulls/142

[Sandro Santilli <strk@…>]

In 3ecd48c7/git:

Fix upgrades in presence of views using st_slope(..raster..)

Adds availability info to the function signatures

References #5490 in master branch (3.5.0dev)

[Sandro Santilli <strk@…>]

In c1f65ad/git:

Fix upgrades in presence of views using st_slope(..raster..)

Adds availability info to the function signatures

Closes #5490 in 3.4 branch (3.4.1dev)