On Fri, May 12, 2023 at 12:13:29PM +0200, Sandro Santilli wrote: > On Tue, May 09, 2023 at 03:59:13PM +0530, Nikhil Shetty wrote: > > > I installed 3.1.5 but we are still having the same issue when upgrading > > > > dbname=# alter extension postgis update ; > [...] > > ERROR: cannot drop function st_distance(geography,geography) because other > > objects depend on it > > DETAIL: materialized view <schemaname>.<viewname> depends on function > > Interesting, did you edit the error log to omit <schemaname> and > <viewname> or is that hiding coming from PostgreSQL itself ? > > This would be worth a ticket to think about ways to handle it, but the > message is pretty clear: PostGIS deprecated a function: > > st_distance(geography, geography) > > But your database is using it in the definition of a materialized view > (which one is hidden). > > We do have code in place to handle deprecations but this specific > function is missing the encantation to be handled properly. Filing > a ticket to https://trac.osgeo.org/postgis will help.
I filed the ticket for you: https://trac.osgeo.org/postgis/ticket/5380#ticket Please consider subscribing to it PS: let this conversation only continue on postgis-devel --strk; _______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
