[postgis-tickets] [SCM] PostGIS branch stable-3.4 updated. 3.4.0-10-g308494525

[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.4 has been updated
       via  308494525858277bbeb546fe36d6aa4c1c157cf7 (commit)
      from  d20df6a22bf075b1a08eaa0ed816f3977fe67bd4 (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 308494525858277bbeb546fe36d6aa4c1c157cf7
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
    
    Closes #5499 in 3.4 (3.4.1dev) branch

diff --git a/NEWS b/NEWS
index 4f8ebbcfb..092199ec0 100644
--- a/NEWS
+++ b/NEWS
@@ -6,6 +6,7 @@ To take advantage of all SFCGAL featurs, SFCGAL 1.4.1+ is needed.
 
 * Bug Fixes *
 
+ - #5499, Fix upgrade with view using st_tileenvelope (Sandro Santilli)
  - #5494, Fix double-upgrade with view using st_dwithin(text, ...)
           (Sandro Santilli)
  - #5491, Fix upgrade with view using st_aspect(raster, ...)
diff --git a/postgis/postgis.sql.in b/postgis/postgis.sql.in
index ab970a5b6..453d71aed 100644
--- a/postgis/postgis.sql.in
+++ b/postgis/postgis.sql.in
@@ -1849,6 +1849,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:
 NEWS                               | 1 +
 postgis/postgis.sql.in             | 1 +
 postgis/postgis_before_upgrade.sql | 8 --------
 3 files changed, 2 insertions(+), 8 deletions(-)


hooks/post-receive
-- 
PostGIS