[SCM] PostGIS branch stable-3.2 updated. 3.2.10-72-g428c1fcc2

[git at osgeo.org]

This is an automated email from the git hooks/post-receive script. It was
generated because a ref change was pushed to the repository containing
the project "PostGIS".

The branch, stable-3.2 has been updated
       via  428c1fcc21d08671b3e69fc091d11660b1112095 (commit)
       via  a84d808df7c7a0bb937817801a57756b28a1b4b4 (commit)
       via  638428c2d3d9042c2d499915944898e935049a4c (commit)
      from  d3422755140c9a93196410f0e4087cb2dd0c043d (commit)

Those revisions listed above that are new to this repository have
not appeared on any other notification email; so we list those
revisions in full, below.

- Log -----------------------------------------------------------------
commit 428c1fcc21d08671b3e69fc091d11660b1112095
Merge: d34227551 a84d808df
Author: Darafei Praliaskouski <komzpa at gmail.com>
Date:   Sun Jul 19 09:00:05 2026 -0700

    Merge pull request 'Repair stable 3.2 upgrade path checks' (!447) from Komzpa/postgis:fix/upgrade-path-hygiene-stable-3.2 into stable-3.2
    
    Reviewed-on: https://gitea.osgeo.org/postgis/postgis/pulls/447


commit a84d808df7c7a0bb937817801a57756b28a1b4b4
Author: Sandro Santilli <strk at kbt.io>
Date:   Sun Jul 19 19:11:15 2026 +0400

    Fix upgrades in presence of views using ST_TileEnvelope
    
    Backport the upgrade marker so create_upgrade.pl handles the replaced ST_TileEnvelope signature instead of forcing the pre-upgrade drop to succeed while dependent objects may still exist.
    
    References #5499 in 3.2 branch
    
    (cherry picked from commit 308494525858277bbeb546fe36d6aa4c1c157cf7)

diff --git a/postgis/postgis.sql.in b/postgis/postgis.sql.in
index d28756e8d..10ed2a260 100644
--- a/postgis/postgis.sql.in
+++ b/postgis/postgis.sql.in
@@ -1807,6 +1807,7 @@ CREATE OR REPLACE FUNCTION ST_MakeEnvelope(float8, float8, float8, float8, integ
 
 -- Availability: 3.0.0
 -- Changed: 3.1.0 - add margin=0.0 parameter
+-- Replaces ST_TileEnvelope(zoom integer, x integer, y integer, bounds geometry) deprecated in 3.1.0
 CREATE OR REPLACE FUNCTION ST_TileEnvelope(zoom integer, x integer, y integer, bounds geometry DEFAULT 'SRID=3857;LINESTRING(-20037508.342789244 -20037508.342789244, 20037508.342789244 20037508.342789244)'::geometry, margin float8 DEFAULT 0.0)
 	RETURNS geometry
 	AS 'MODULE_PATHNAME', 'ST_TileEnvelope'
diff --git a/postgis/postgis_before_upgrade.sql b/postgis/postgis_before_upgrade.sql
index 11a599d8d..d5d887e77 100644
--- a/postgis/postgis_before_upgrade.sql
+++ b/postgis/postgis_before_upgrade.sql
@@ -183,14 +183,6 @@ SELECT _postgis_drop_function_if_needed
 	'GeometryA geometry, GeometryB geometry'
 	);
 
--- FUNCTION st_tileenvelope added a new default argument in 3.1
-SELECT _postgis_drop_function_if_needed
-    (
-    'st_tileenvelope',
-    'zoom integer, x integer, y integer, bounds geometry'
-    );
-
-
 -- FUNCTION st_buffer changed to add defaults in 3.0
 -- This signature was superseeded
 DROP FUNCTION IF EXISTS st_buffer(geometry, double precision); -- Does not conflict
@@ -242,4 +234,3 @@ $$;
 
 -- DROP auxiliar function (created above)
 DROP FUNCTION _postgis_drop_function_if_needed(text, text);
-

commit 638428c2d3d9042c2d499915944898e935049a4c
Author: Darafei Praliaskouski <me at komzpa.net>
Date:   Sun Jul 19 19:11:08 2026 +0400

    upgrade: clean stale target-version paths before install
    
    Remove previously installed upgrade scripts for the target extension version before recreating the branch-declared symlink set. This keeps shared extension directories from exposing stale downgrade paths that the current branch no longer installs.

diff --git a/extensions/upgrade-paths-rules.mk b/extensions/upgrade-paths-rules.mk
index 27dff04bb..730c81cb5 100644
--- a/extensions/upgrade-paths-rules.mk
+++ b/extensions/upgrade-paths-rules.mk
@@ -6,6 +6,7 @@ install: install-upgrade-paths
 # revisions of the same version
 install-upgrade-paths:
 	tpl='$(EXTENSION)--ANY--$(EXTVERSION).sql'; \
+	rm -f "$(EXTDIR)/$(EXTENSION)--"*--"$(EXTVERSION).sql"; \
 	$(INSTALL_DATA) sql/$${tpl} "$(EXTDIR)/$${tpl}"; \
 	ln -fs "$${tpl}" $(EXTDIR)/$(EXTENSION)--$(EXTVERSION)--$(EXTVERSION)next.sql; \
 	ln -fs "$${tpl}" $(EXTDIR)/$(EXTENSION)--$(EXTVERSION)next--$(EXTVERSION).sql; \

-----------------------------------------------------------------------

Summary of changes:
 extensions/upgrade-paths-rules.mk  | 1 +
 postgis/postgis.sql.in             | 1 +
 postgis/postgis_before_upgrade.sql | 9 ---------
 3 files changed, 2 insertions(+), 9 deletions(-)


hooks/post-receive
-- 
PostGIS