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

[Nikhil Shetty]

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 upgrading, if you want to drop raster, run: DROP EXTENSION
postgis_raster;
WARNING: Deprecated function
st_intersection_deprecated_by_postgis_301(geometry,geometry) left behind:
cannot drop function
st_intersection_deprecated_by_postgis_301(geometry,geometry) because other
objects depend on it
DETAIL: function s.st_disunion(geometry) depends on function
st_intersection_deprecated_by_postgis_301(geometry,geometry)
view <viewname> depends on function
st_intersection_deprecated_by_postgis_301(geometry,geometry)
HINT: Replace the view changing all occurrences of
st_intersection_deprecated_by_postgis_301(geometry,geometry) in its
definition with st_intersection(geometry,geometry) and upgrade again
ERROR: cannot drop function st_distance(geography,geography) because other
objects depend on it
DETAIL: materialized view <schemaname>.<viewname> depends on function
st_distance(geography,geography)
materialized view <schemaname>.<viewname> depends on function
st_distance(geography,geography)
materialized view <schemaname>.<viewname> depends on function
st_distance(geography,geography)
materialized view <schemaname>.<viewname> depends on function
st_distance(geography,geography)
materialized view <schemaname>.<viewname> depends on function
st_distance(geography,geography)
materialized view <schemaname>.<viewname> depends on function
st_distance(geography,geography)
materialized view <schemaname>.<viewname> depends on function
st_distance(geography,geography)
materialized view <schemaname>.<viewname> depends on function
st_distance(geography,geography)
materialized view <schemaname>.<viewname> depends on materialized view
<schemaname>.<viewname>
materialized view <schemaname>.<viewname> depends on materialized view
<schemaname>.<viewname>
materialized view <schemaname>.<viewname> depends on materialized view
<schemaname>.<viewname>
view <schemaname>.<viewname> depends on function
st_distance(geography,geography)
view <schemaname>.<viewname> depends on function
st_distance(geography,geography)
HINT: Use DROP ... CASCADE to drop the dependent objects too.


Thanks,
Nikhil

On Tue, Apr 18, 2023 at 5:12 PM Sandro Santilli <strk at kbt.io> wrote:

> 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,
> some of which are security releated. Why holding back ?
>
>   PostGIS 3.1.8
>   2022/11/12
>
>   * Bug and Security Fixes
>     - [security] Add schema qual to upgrade util (Regina Obe)
>     - #5240, ST_DumpPoints crash with empty polygon (Regina Obe)
>     - #4648, [security] Check function ownership at extension packaging
>              time (Sandro Santilli)
>       Thanks to Sven Klemm (Timescale) for the report
>     - #5241, Crash on ST_SnapToGrid with empty multis (Regina Obe)
>     - #5234, Fix 2.5d topology building regression (Sandro Santilli)
>     - #5280, Handle load of dbase character fields with no width
>              specified (Regina Obe)
>     - #5084, Bad rasterization of linestring (Gilles Vuidel)
>
>   PostGIS 3.1.7
>   2022/08/18
>
>   * Bug Fixes
>     - #5191, Use integer instead of int4 (Regina Obe)
>     - #5139, PostGIS causes to_jsonb to no longer be parallel safe,
>              ST_AsGeoJSON and ST_AsGML are also parallel unsafe
>              (Regina Obe, Paul Ramsey)
>     - #5202, Guard against downgrades (Sandro Santilli)
>     - #5209, #5210, Fix upgrades with CVE-2022-2625 PostgreSQL fix
>     - #5032, Correctly read extent off multi-key GIST indexes (Paul Ramsey)
>     - #5181, Reset proj error state after failed parse (Paul Ramsey)
>     - #5171, Short circuit geodesic distance when inputs equal (Paul
> Ramsey)
>     - Fix potential buffer overflow in long transaction locks (Paul
>       Ramsey)
>
>
>   PostGIS 3.1.6
>   2022/07/20
>
>   * Bug Fixes
>     - #4835, Occasional distance errors in polar area (Paul Ramsey)
>     - #5152, Fix infinite loop with ST_Split (Sandro Santilli)
>     - #5120, Fix not-null result from ST_EstimatedExtent against
>              truncated tables with spatial index (Sandro Santilli)
>     - #5076, Avoid log storm installed with pgaudit enabled (Paul Ramsey)
>     - #5100, Stop using pg_atoi, removed in PG 15 (Laurenz Albe)
>     - #5115, Allow dropping topologies with pending constraints (Sandro
> Santilli)
>     - #5151, ST_SetPoint with empty geometries (Regina Obe)
>     - #5150, Change signature of AddToSearchPath (Regina Obe)
>     - #5125, Fix search path function (Sandro Santilli)
>     - #5155, More schema qual fixes (Regina Obe)
>     - #5114, Crash with long column names in pgsql2shp (Paul Ramsey)
>     - #4541, ST_ConcaveHull returns a "geometrycollection" type
>              instead of the expected "polygon" (Regina Obe)
>     - #5154, raster ST_Value is undercosted (Regina Obe)
>
> --strk;
>
>   Libre GIS consultant/developer
>   https://strk.kbt.io/services.html
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-devel
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20230509/b4d6f807/attachment.htm>