#5491 closed defect (fixed)

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

Reported by: strk Owned by: strk
Priority: medium Milestone: PostGIS 3.4.1
Component: build Version: 3.4.x
Keywords: raster Cc:

Description

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

Change History (5)

comment:1 by strk, 14 months ago

Summary: Upgrade from 3.1.1: RROR: cannot drop function st_aspect(raster,integer,text,text,boolean) because other objects depend on itUpgrade from 3.1.1: ERROR: cannot drop function st_aspect(raster,integer,text,text,boolean) because other objects depend on it

comment:2 by strk, 14 months ago

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[])

comment:4 by Sandro Santilli <strk@…>, 13 months ago

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)

comment:5 by Sandro Santilli <strk@…>, 13 months ago

Resolution: fixed
Status: newclosed

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)

Note: See TracTickets for help on using tickets.