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
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
>
Hi Sandro,
I installed 3.1.5 but we are still having the same issue when upgrading
dbname=# alter extension postgis update ;
WARNING: unpackaging raster
WARNING: PostGIS Raster functionality has been unpackaged
HINT: type `SELECT postgis_extensions_upgrade();` to finish the upgrade.
After
On Tue, Apr 18, 2023 at 12:14:55AM +0530, Nikhil Shetty wrote:
> We will try upgrading to 3.1.5
I'd go to 3.1.8 which came out on 2022/11/12
All these patch-level releases really ONLY contain bug fixes,
no new features, no new bugs.
If you upgrade to 3.1.5 you'll miss all the following fixes,
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
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
> >
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
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
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
On Fri, Apr 14, 2023 at 01:29:02PM +0530, Nikhil Shetty wrote:
> geo=# alter extension postgis update to '3.1.2';
> ERROR: could not access file "$libdir/postgis-2.5": No such file or directory
[...]
> We removed the old 2.5.4 packages and installed 3.1.2
>
> ls -l /usr/pgsql-10/lib | grep
10 matches
Mail list logo