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