#34096 closed Cleanup/optimization (invalid)
I might came across a bug when updating to the latest version of postgis
Reported by: | spechtx | Owned by: | |
---|---|---|---|
Component: | contrib.postgres | Version: | 4.1 |
Severity: | Normal | Keywords: | |
Cc: | Triage Stage: | Unreviewed | |
Has patch: | no | Needs documentation: | no |
Needs tests: | no | Patch needs improvement: | no |
Easy pickings: | no | UI/UX: | no |
Description
this code produces an error:
from django.contrib.gis.db.models.aggregates import Union geom = instance.location_characteristic.all().aggregate(union=Union('geom'))
django.db.utils.NotSupportedError: A stored procedure tried to use deprecated C function 'pgis_geometry_union_finalfn' DETAIL: Library function 'pgis_geometry_union_finalfn' was deprecated in PostGIS 3.3.0 HINT: Consider running: SELECT postgis_extensions_upgrade()
Even downgrading to the last postis version
ALTER EXTENSION postgis UPDATE TO '3.2.3';
doesn't seem to solve the issue...
Change History (2)
comment:1 by , 2 years ago
Resolution: | → invalid |
---|---|
Severity: | Release blocker → Normal |
Status: | new → closed |
comment:2 by , 2 years ago
Luckily, you are very right :-)
For anyone coming across this via search, I was able to resolve the issue with
SELECT postgis_extensions_upgrade();
on the database
thank you
Note:
See TracTickets
for help on using tickets.
Thanks for the report, however it's not an issue in Django but in upgrading the local PostGIS version.