Opened 2 years ago

Closed 2 years ago

Last modified 2 years ago

#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 Mariusz Felisiak, 2 years ago

Resolution: invalid
Severity: Release blockerNormal
Status: newclosed

Thanks for the report, however it's not an issue in Django but in upgrading the local PostGIS version.

comment:2 by spechtx, 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.
Back to Top