[Django] #34096: I might came across a bug when updating to the latest version of postgis
Django
------------------------------------------------+------------------------
Reporter: spechtx | Owner: (none)
Type: Cleanup/optimization | Status: new
Component: contrib.postgres | Version: 4.1
Severity: Release blocker | Keywords:
Triage Stage: Unreviewed | Has patch: 0
Needs documentation: 0 | Needs tests: 0
Patch needs improvement: 0 | Easy pickings: 0
UI/UX: 0 |
------------------------------------------------+------------------------
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...
--
Ticket URL: <https://code.djangoproject.com/ticket/34096>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
Django
Reporter: spechtx | Owner: (none)
Type: | Status: closed
Cleanup/optimization |
Component: contrib.postgres | Version: 4.1
Severity: Normal | Resolution: invalid
Keywords: | Triage Stage:
| Unreviewed
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
Changes (by Mariusz Felisiak):
* status: new => closed
* resolution: => invalid
* severity: Release blocker => Normal
Comment:
Thanks for the report, however it's not an issue in Django but in
upgrading the local PostGIS version.
--
Ticket URL: <https://code.djangoproject.com/ticket/34096#comment:1>
Django
-------------------------------------+-------------------------------------
Reporter: spechtx | Owner: (none)
Type: | Status: closed
Cleanup/optimization |
Component: contrib.postgres | Version: 4.1
Severity: Normal | Resolution: invalid
Keywords: | Triage Stage:
| Unreviewed
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Comment (by spechtx):
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
--
Ticket URL: <https://code.djangoproject.com/ticket/34096#comment:2>