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

[Nikhil Shetty]

Hi Sandro,

Q: Interesting, did you edit the error log to omit <schemaname> and
<viewname> or is that hiding coming from PostgreSQL itself ?
A: Yes, we edited the error log to mask the names

Thank you for filing the ticket. I got few more errors below which could be
added in ticket

1. We had to drop below aggregate functions because st_combine_bbox is
renamed to st_combinebbox
create aggregate public.st_extent3d(box3d) (sfunc = public.st_combine_bbox,
stype = box3d) - use st_combinebbox , st_3dextent
create aggregate public.extent(box3d) (sfunc = public.st_combine_bbox,
stype = box3d) - use st_combinebbox

 2. We had to drop an aggregate function(s.st_disunion) and a view for
dependency on st_intersection
ERROR: cannot drop function st_intersection(geometry,geometry) because
other objects depend on it
DETAIL: function s.st_disunion(geometry) depends on function
st_intersection(geometry,geometry)
view <viewname> depends on function st_intersection(geometry,geometry)

Thanks,
Nikhil


On Fri, May 12, 2023 at 7:15 PM Sandro Santilli <strk at kbt.io> wrote:

> 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;
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20230515/7aa023eb/attachment.htm>