[postgis-devel] [postgis-users] Error Upgrading PostGIS 2.5.4 to 3.1.2

[Sandro Santilli]

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;