Upgrade from 3.1.1: ERROR: cannot drop function st_aspect(raster,integer,text,text,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_aspect(raster,integer,text,text,boolean) because other objects depend on it

See also #5489

[strk]

Current signatures (2.1.0 to current master aka 3.5.0dev):

--1
st_aspect(
 rast raster,
 nband integer,
 customextent raster,
 pixeltype text DEFAULT '32BF',
 units text DEFAULT 'DEGREES',
 interpolate_nodata boolean DEFAULT FALSE
)
--2
st_aspect(
 rast raster,
 nband integer DEFAULT 1,
 pixeltype text DEFAULT '32BF',
 units text DEFAULT 'DEGREES',
 interpolate_nodata boolean DEFAULT FALSE
)

stable-2.0 had instead only:

st_aspect(rast raster, band integer, pixeltype text)

Internal function being used is _st_aspect4ma which has current (2.1.0—master) signature

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

and stable-2.0 signature:

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

[strk]

WIP pr: ​https://git.osgeo.org/gitea/postgis/postgis/pulls/143

[Sandro Santilli <strk@…>]

In 197a187/git:

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

Adds functions availability info

References #5491 in master branch (3.5.0dev)

[Sandro Santilli <strk@…>]

In 2bf50fa/git:

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

Adds functions availability info

Closes #5491 in 3.4 branch (3.4.1dev)