[postgis-devel] Error Upgrading PostGIS 2.5.4 to 3.1.2

[Sandro Santilli]

On Mon, Apr 17, 2023 at 03:18:50PM +0530, Nikhil Shetty wrote:

> DETAIL:  view xxxxx depends on function st_buffer(geometry,double precision)
> DETAIL:  function xxxxx depends on function st_intersection(geometry,geometry)
> DETAIL:  view xxxxx depends on function st_intersection(geometry,geometry)

[...]

> Is there a way to identify the list of objects being dropped? and which all
> views/functions depend on these dropped objects?

Probably, but you should really consider upgrading to a newer version.
We added the ability to continue the upgrade in these cases by keeping
the "orphaning" the old functions, and having them reported by a
call to `SELECT postgis_full_version()` so that should give you the
list. See https://trac.osgeo.org/postgis/ticket/5033#comment:6

--strk;