Opened 22 months ago
Closed 17 months ago
#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 , 22 months ago
comment:2 by , 19 months ago
Milestone: | PostGIS 3.3.3 → PostGIS 3.4.0 |
---|
comment:3 by , 17 months ago
Resolution: | → wontfix |
---|---|
Status: | new → closed |
Note:
See TracTickets
for help on using tickets.
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.