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

2023-04-17 Thread Nikhil Shetty
Sure Sandro, We will try upgrading to 3.1.5 Thanks, Nikhil On Mon, 17 Apr 2023 at 20:39, Sandro Santilli 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 x depends on functio

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

2023-04-17 Thread 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 x depends on function st_buffer(geometry,double precision) > > DETAIL: function x depends on function > > st_intersection(geometry,geometr

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

2023-04-17 Thread Sandro Santilli
On Mon, Apr 17, 2023 at 03:18:50PM +0530, Nikhil Shetty wrote: > DETAIL: view x depends on function st_buffer(geometry,double precision) > DETAIL: function x depends on function st_intersection(geometry,geometry) > DETAIL: view x depends on function st_intersection(geometry,geometry

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

2023-04-17 Thread Nikhil Shetty
Hi Sandro, Old error is gone after the workaround( I had to add a hyphen in 2.5 in sed command). I see we are getting different error now and looks like there are a lot of objects dependent on functions which are being dropped. db1=# alter extension postgis update; WARNING: unpackaging raster

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

2023-04-17 Thread Nikhil Shetty
Hi Sandro, Thank you, I will try the workaround BUT I'm wondering: why would you want to upgrade to 3.1.2 when the latest PostGIS version in the 3.1 branch is 3.1.8 ? -- We started with the upgrade at a time when 3.1.2 was the latest version. We will try to add the newer version in future upgrad