[postgis-tickets] [SCM] PostGIS branch master updated. 3.4.0rc1-75-g4fc205e12

[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, master has been updated
       via  4fc205e128859cafd89cf3e8002031805ce8f51f (commit)
      from  84ed93553a337f034c90f5407d1549cebae28efa (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 4fc205e128859cafd89cf3e8002031805ce8f51f
Author: Sandro Santilli <strk at kbt.io>
Date:   Wed Aug 30 11:18:46 2023 +0200

    Fix upgrades in presence of views using ST_TileEnvelope
    
    References #5499 in master (3.5.0dev) branch

diff --git a/postgis/postgis.sql.in b/postgis/postgis.sql.in
index bce4c27f6..eca94b041 100644
--- a/postgis/postgis.sql.in
+++ b/postgis/postgis.sql.in
@@ -1862,6 +1862,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 7968f5356..da945fc44 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

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

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


hooks/post-receive
-- 
PostGIS