#5330 closed defect (wontfix)

postgis_extensions_upgrade() bail out if you dn't have all extensions

Reported by: strk Owned by: strk
Priority: medium Milestone: PostGIS 3.4.0
Component: build Version: 3.3.x
Keywords: Cc:

Description

If you enable less extensions than you had in a database, when you upgrade using postgis_extensions_upgrade() nothing is upgraded. Rather you get error like:

strk=# select postgis_extensions_upgrade();
NOTICE:  Updating extension postgis 3.3.2
NOTICE:  Updating extension postgis_sfcgal 3.3.2
ERROR:  extension "postgis_sfcgal" has no update path from version "ANY" to version "3.4.0dev"

I guess it would be nice for the function to STILL do partial upgrade (upgrade extensions that can be upgraded) -- maybe you realize you don't need/want the others and you drop them instead ?

Change History (3)

comment:1 by strk, 22 months ago

Regina convinced me this is an acceptable behaviour. Just drop postgis_sfcgal if you don't want to upgrade it.

Maybe the message could be more meaningful (what's "ANY"??) but the behaviour on itself isn't that bad. Upgrade is successful after you drop the "postgis_sfcgal" extension.

comment:2 by robe, 19 months ago

Milestone: PostGIS 3.3.3PostGIS 3.4.0

comment:3 by robe, 17 months ago

Resolution: wontfix
Status: newclosed
Note: See TracTickets for help on using tickets.