#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 , 3 years ago
| Resolution: | → invalid |
|---|---|
| Severity: | Release blocker → Normal |
| Status: | new → closed |
comment:2 by , 3 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.