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

[Sandro Santilli]

On Mon, Apr 17, 2023 at 04:56:06PM +0200, Sandro Santilli wrote:
> 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

I'll add: according to the NEWS file this improved upgrade support was
included in PostGIS version 3.1.5:

  https://git.osgeo.org/gitea/postgis/postgis/src/tag/3.1.5/NEWS#L10

--strk;