<div dir="ltr">Hi Sandro,<div><br></div><div>I installed 3.1.5 but we are still having the same issue when upgrading</div><div><br></div><div><div style="color:rgb(0,0,0);font-family:Menlo,Monaco,"Courier New",monospace;font-size:12px;line-height:18px;white-space:pre"><div>dbname=<span style="color:rgb(0,128,0)"># alter extension postgis update ;</span></div><div>WARNING: unpackaging raster</div><div>WARNING: PostGIS Raster functionality has been unpackaged</div><div>HINT: <span style="color:rgb(38,127,153)">type</span> <span style="color:rgb(205,49,49)">`SELECT postgis_extensions_upgrade();`</span> to finish the upgrade. After upgrading, <span style="color:rgb(175,0,219)">if</span> you want to drop raster, run: DROP EXTENSION postgis_raster;</div><div>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</div><div>DETAIL: function s.st_disunion(geometry) depends on function st_intersection_deprecated_by_postgis_301(geometry,geometry)</div><div>view <viewname> depends on function st_intersection_deprecated_by_postgis_301(geometry,geometry)</div><div>HINT: Replace the view changing <span style="color:rgb(121,94,38)">all</span> occurrences of st_intersection_deprecated_by_postgis_301(geometry,geometry) <span style="color:rgb(175,0,219)">in</span> its definition <span style="color:rgb(175,0,219)">with</span> st_intersection(geometry,geometry) <span style="color:rgb(0,0,255)">and</span> upgrade again</div></div>
<div style="color:rgb(0,0,0);font-family:Menlo,Monaco,"Courier New",monospace;font-size:12px;line-height:18px;white-space:pre"><div>ERROR: cannot drop function st_distance(geography,geography) because other objects depend on it</div><div>DETAIL: materialized view <schemaname>.<viewname> depends on function st_distance(geography,geography)</div><div>materialized view <schemaname>.<viewname> depends on function st_distance(geography,geography)</div><div>materialized view <schemaname>.<viewname> depends on function st_distance(geography,geography)</div><div>materialized view <schemaname>.<viewname> depends on function st_distance(geography,geography)</div><div>materialized view <schemaname>.<viewname> depends on function st_distance(geography,geography)</div><div>materialized view <schemaname>.<viewname> depends on function st_distance(geography,geography)</div><div>materialized view <schemaname>.<viewname> depends on function st_distance(geography,geography)</div><div>materialized view <schemaname>.<viewname> depends on function st_distance(geography,geography)</div><div>materialized view <schemaname>.<viewname> depends on materialized view <schemaname>.<viewname></div><div>materialized view <schemaname>.<viewname> depends on materialized view <schemaname>.<viewname></div><div>materialized view <schemaname>.<viewname> depends on materialized view <schemaname>.<viewname></div><div>view <schemaname>.<viewname> depends on function st_distance(geography,geography)</div><div>view <schemaname>.<viewname> depends on function st_distance(geography,geography)</div><div>HINT: Use DROP ... CASCADE to drop the dependent objects too.</div><div><br></div></div><p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><br></span></p></div><div>Thanks,</div><div>Nikhil</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, Apr 18, 2023 at 5:12 PM Sandro Santilli <<a href="mailto:strk@kbt.io">strk@kbt.io</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">On Tue, Apr 18, 2023 at 12:14:55AM +0530, Nikhil Shetty wrote:<br>
<br>
> We will try upgrading to 3.1.5<br>
<br>
I'd go to 3.1.8 which came out on 2022/11/12<br>
All these patch-level releases really ONLY contain bug fixes,<br>
no new features, no new bugs.<br>
<br>
If you upgrade to 3.1.5 you'll miss all the following fixes,<br>
some of which are security releated. Why holding back ?<br>
<br>
PostGIS 3.1.8<br>
2022/11/12<br>
<br>
* Bug and Security Fixes<br>
- [security] Add schema qual to upgrade util (Regina Obe)<br>
- #5240, ST_DumpPoints crash with empty polygon (Regina Obe)<br>
- #4648, [security] Check function ownership at extension packaging<br>
time (Sandro Santilli)<br>
Thanks to Sven Klemm (Timescale) for the report<br>
- #5241, Crash on ST_SnapToGrid with empty multis (Regina Obe)<br>
- #5234, Fix 2.5d topology building regression (Sandro Santilli)<br>
- #5280, Handle load of dbase character fields with no width<br>
specified (Regina Obe)<br>
- #5084, Bad rasterization of linestring (Gilles Vuidel)<br>
<br>
PostGIS 3.1.7<br>
2022/08/18<br>
<br>
* Bug Fixes<br>
- #5191, Use integer instead of int4 (Regina Obe)<br>
- #5139, PostGIS causes to_jsonb to no longer be parallel safe,<br>
ST_AsGeoJSON and ST_AsGML are also parallel unsafe<br>
(Regina Obe, Paul Ramsey)<br>
- #5202, Guard against downgrades (Sandro Santilli)<br>
- #5209, #5210, Fix upgrades with CVE-2022-2625 PostgreSQL fix<br>
- #5032, Correctly read extent off multi-key GIST indexes (Paul Ramsey)<br>
- #5181, Reset proj error state after failed parse (Paul Ramsey)<br>
- #5171, Short circuit geodesic distance when inputs equal (Paul Ramsey)<br>
- Fix potential buffer overflow in long transaction locks (Paul<br>
Ramsey)<br>
<br>
<br>
PostGIS 3.1.6<br>
2022/07/20<br>
<br>
* Bug Fixes<br>
- #4835, Occasional distance errors in polar area (Paul Ramsey)<br>
- #5152, Fix infinite loop with ST_Split (Sandro Santilli)<br>
- #5120, Fix not-null result from ST_EstimatedExtent against<br>
truncated tables with spatial index (Sandro Santilli)<br>
- #5076, Avoid log storm installed with pgaudit enabled (Paul Ramsey)<br>
- #5100, Stop using pg_atoi, removed in PG 15 (Laurenz Albe)<br>
- #5115, Allow dropping topologies with pending constraints (Sandro Santilli)<br>
- #5151, ST_SetPoint with empty geometries (Regina Obe)<br>
- #5150, Change signature of AddToSearchPath (Regina Obe)<br>
- #5125, Fix search path function (Sandro Santilli)<br>
- #5155, More schema qual fixes (Regina Obe)<br>
- #5114, Crash with long column names in pgsql2shp (Paul Ramsey)<br>
- #4541, ST_ConcaveHull returns a "geometrycollection" type<br>
instead of the expected "polygon" (Regina Obe)<br>
- #5154, raster ST_Value is undercosted (Regina Obe)<br>
<br>
--strk;<br>
<br>
Libre GIS consultant/developer<br>
<a href="https://strk.kbt.io/services.html" rel="noreferrer" target="_blank">https://strk.kbt.io/services.html</a><br>
_______________________________________________<br>
postgis-devel mailing list<br>
<a href="mailto:postgis-devel@lists.osgeo.org" target="_blank">postgis-devel@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-devel" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-devel</a><br>
</blockquote></div>