[SCM] PostGIS branch stable-3.3 updated. 3.3.10-73-gd054ff28b

[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.3 has been updated
       via  d054ff28b5cc729bc63b8b986f5f09904cf8c289 (commit)
       via  fc667d5a9f5cbd8bc26e1d728e43b2d5fc75bf89 (commit)
      from  c849380298c5a9e6354876f519b999408ab632e0 (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 d054ff28b5cc729bc63b8b986f5f09904cf8c289
Merge: c84938029 fc667d5a9
Author: Darafei Praliaskouski <komzpa at gmail.com>
Date:   Sun Jul 19 08:59:32 2026 -0700

    Merge pull request 'Backport ST_TileEnvelope upgrade marker to stable 3.3' (!446) from Komzpa/postgis:fix/tileenvelope-upgrade-stable-3.3 into stable-3.3
    
    Reviewed-on: https://gitea.osgeo.org/postgis/postgis/pulls/446


commit fc667d5a9f5cbd8bc26e1d728e43b2d5fc75bf89
Author: Sandro Santilli <strk at kbt.io>
Date:   Sun Jul 19 19:03:12 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.3 branch
    
    (cherry picked from commit 308494525858277bbeb546fe36d6aa4c1c157cf7)

diff --git a/postgis/postgis.sql.in b/postgis/postgis.sql.in
index 815f13c63..54eca5b18 100644
--- a/postgis/postgis.sql.in
+++ b/postgis/postgis.sql.in
@@ -1817,6 +1817,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 f901b22da..30293e7c6 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);
-

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

Summary of changes:
 postgis/postgis.sql.in             | 1 +
 postgis/postgis_before_upgrade.sql | 9 ---------
 2 files changed, 1 insertion(+), 9 deletions(-)


hooks/post-receive
-- 
PostGIS