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

[Nikhil Shetty]

Hi Sandro,

I see the ticket https://trac.osgeo.org/postgis/ticket/5380#ticket is
closed, what did we do to fix it and on which version ?

With this fix, if I do the upgrade, will it do the upgrade without errors ?

Thanks,
Nikhil

On Mon, May 15, 2023 at 3:14 PM Nikhil Shetty <nikhil.dba04 at gmail.com>
wrote:

> 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/53b3729f/attachment.htm>