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 <s...@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-de...@lists.osgeo.org > https://lists.osgeo.org/mailman/listinfo/postgis-devel >
_______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
