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. --strk; _______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
