Opened 8 months ago

Closed 7 months ago

#5517 closed defect (fixed)

ERROR: cannot drop function st_count(text,text,integer,boolean) because other objects depend on it

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

Description

This happens upgrading from 3.0.9dev to 3.5.0dev Upgrading from 3.1.6dev and later are fine

Change History (6)

comment:1 by strk, 8 months ago

PR https://git.osgeo.org/gitea/postgis/postgis/pulls/145 should enable CI to show this problem

comment:3 by strk, 8 months ago

There are 2 signatures in 3.0 that have been deprecated in 3.1.0 (ref #4214):

st_count(rastertable text, rastercolumn text, nband int DEFAULT 1, exclude_nodata_value boolean DEFAULT TRUE)
st_count(rastertable text, rastercolumn text, exclude_nodata_value boolean)

We'd need to threat the deprecated function the same as we do with the "Replaces" (ie: rename to deprecated)

I guess we could use the same "Replaces" comment to deal with these

comment:4 by strk, 8 months ago

According to https://postgis.net/docs/en/RT_ST_Count.html the function signature was replaced by the ST_CountAgg aggregate.

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

In 58780c6f/git:

Deprecate older raster functions instead of dropping them

Fix raster unpackaging script creator to handle script based drops

in master (3.5.0dev) branch:

References #5516 #5517 #5502 #5503 #5504 #5505 #5506 #5507 #5508

#5509 #5510 #5511 #5512 #5513 #5514 #5515 #5516

comment:6 by strk, 7 months ago

Resolution: fixed
Status: newclosed

Closed by [e428b70577bd51d3924346d9f0124a6d37ef4ff8/git] in 3.4 branch (3.4.1dev)

Note: See TracTickets for help on using tickets.