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

[Nikhil Shetty]

Sure Sandro,

We will try upgrading to 3.1.5

Thanks,
Nikhil

On Mon, 17 Apr 2023 at 20:39, Sandro Santilli <strk at kbt.io> wrote:

> 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 at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20230418/32bd32ac/attachment.htm>