#4728 closed defect (fixed)
Remove UPDATE for pgis_abs from upgrade script
| Reported by: | khannaekta | Owned by: | pramsey |
|---|---|---|---|
| Priority: | medium | Milestone: | PostGIS 2.5.5 |
| Component: | postgis | Version: | 2.5.x -- EOL |
| Keywords: | Cc: |
Description
PostGIS 2.5 onwards pgis_abs type was removed from aggregate/collect routines, but if we look at the upgrade script for versions >=2.5, they still contain an UPDATE for pgis_abs type in the catalog table (https://git.osgeo.org/gitea/postgis/postgis/src/branch/master/postgis/postgis_after_upgrade.sql#L233-L235). Is there a reason we have it else it should be part of versions >=2.5.
Change History (5)
follow-up: 5 comment:1 by , 4 years ago
comment:5 by , 4 years ago
Replying to strk:
No reason. Indeed the type is DROP in the same file, earlier. It was removed as per #4035 in 2.5.0. I'll drop that UPDATE. Good catch! (how did you find out ?)
Thanks for the quick fix. I bumped int this when trying to upgrade from 2.1.5 -> 2.5.4 using ALTER EXTENSION postgis UPDATE to '2.5.4'; and it failed with the following error:
ERROR: permission denied: "pg_type" is a system catalog.
No reason. Indeed the type is DROP in the same file, earlier. It was removed as per #4035 in 2.5.0. I'll drop that UPDATE. Good catch! (how did you find out ?)