[postgis-tickets] [SCM] PostGIS branch stable-3.4 updated. 3.4.0-38-ge5dd8a1b8

[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  e5dd8a1b8dfd0133dc3a51f7a73f4b4b49109f51 (commit)
      from  9c44d61fdcb9c8ef54c82ee6e15a29df985cadf9 (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 e5dd8a1b8dfd0133dc3a51f7a73f4b4b49109f51
Author: Sandro Santilli <strk at kbt.io>
Date:   Tue Oct 17 23:06:54 2023 +0200

    Propery drop st_quantile and st_approxquantile signatures deprecated in 3.1
    
    Close #5578 #5579 in 3.4 branch (3.4.1dev)

diff --git a/NEWS b/NEWS
index 9d02a0a8a..83a9091eb 100644
--- a/NEWS
+++ b/NEWS
@@ -7,7 +7,8 @@ To take advantage of all SFCGAL featurs, SFCGAL 1.4.1+ is needed.
 * Bug Fixes *
 
 
- - #5574, #5575, #5576, #5577, Fix restore of postgis dumps (Sandro Santilli)
+ - #5574, #5575, #5576, #5577, #5578, #5579,
+          Fix restore of postgis dumps (Sandro Santilli)
  - #5568, Improve robustness of topology face split handling (Sandro Santilli)
  - #5548, Fix box-filtered validity check of topologies with edge-less faces
           (Sandro Santilli)
diff --git a/raster/rt_pg/rtpostgis_upgrade_cleanup.sql.in b/raster/rt_pg/rtpostgis_upgrade_cleanup.sql.in
index 4eb95a95e..3d75f71c0 100644
--- a/raster/rt_pg/rtpostgis_upgrade_cleanup.sql.in
+++ b/raster/rt_pg/rtpostgis_upgrade_cleanup.sql.in
@@ -277,23 +277,32 @@ SELECT _postgis_drop_function_by_signature('_st_summarystats(raster,int, boolean
 SELECT _postgis_drop_function_by_signature('_st_summarystats(text, text,integer, boolean, double precision)');
 
 -- remove TYPE quantile
-SELECT _postgis_drop_function_by_signature('st_quantile(raster, int, boolean, double precision[])');
-SELECT _postgis_drop_function_by_signature('st_quantile(raster, int, double precision[])');
-SELECT _postgis_drop_function_by_signature('st_quantile(raster, double precision[])');
+SELECT _postgis_drop_function_by_signature('st_approxquantile(raster, double precision[])');
+SELECT _postgis_drop_function_by_signature('st_approxquantile(raster, double precision, double precision[])');
 SELECT _postgis_drop_function_by_signature('st_approxquantile(raster, int, boolean, double precision, double precision[])');
 SELECT _postgis_drop_function_by_signature('st_approxquantile(raster, int, double precision, double precision[])');
-SELECT _postgis_drop_function_by_signature('st_approxquantile(raster, double precision, double precision[])');
-SELECT _postgis_drop_function_by_signature('st_approxquantile(raster, double precision[])');
-SELECT _postgis_drop_function_by_signature('st_quantile(text, text, int, boolean, double precision[])');
-SELECT _postgis_drop_function_by_signature('st_quantile(text, text, int, double precision[])');
-SELECT _postgis_drop_function_by_signature('st_quantile(text, text, double precision[])');
+SELECT _postgis_drop_function_by_signature('st_approxquantile(text, text, boolean, double precision)', '3.1.0'); -- See https://trac.osgeo.org/postgis/ticket/5578
+SELECT _postgis_drop_function_by_signature('st_approxquantile(text, text, double precision[])');
+SELECT _postgis_drop_function_by_signature('st_approxquantile(text, text, double precision)', '3.1.0'); -- See https://trac.osgeo.org/postgis/ticket/5578
+SELECT _postgis_drop_function_by_signature('st_approxquantile(text, text, double precision, double precision[])');
+SELECT _postgis_drop_function_by_signature('st_approxquantile(text, text, double precision, double precision)', '3.1.0'); -- See https://trac.osgeo.org/postgis/ticket/5578
 SELECT _postgis_drop_function_by_signature('st_approxquantile(text, text, int, boolean, double precision, double precision[])');
 SELECT _postgis_drop_function_by_signature('st_approxquantile(text, text, int, double precision, double precision[])');
-SELECT _postgis_drop_function_by_signature('st_approxquantile(text, text, double precision, double precision[])');
-SELECT _postgis_drop_function_by_signature('st_approxquantile(text, text, double precision[])');
+SELECT _postgis_drop_function_by_signature('st_approxquantile(text, text, integer, boolean, double precision, double precision)', '3.1.0'); -- See https://trac.osgeo.org/postgis/ticket/5578
+SELECT _postgis_drop_function_by_signature('st_approxquantile(text, text, integer, double precision, double precision)', '3.1.0'); -- See https://trac.osgeo.org/postgis/ticket/5578
+SELECT _postgis_drop_function_by_signature('st_quantile(raster, double precision[])');
+SELECT _postgis_drop_function_by_signature('st_quantile(raster, int, boolean, double precision[])');
 SELECT _postgis_drop_function_by_signature('_st_quantile(raster, int, boolean, double precision, double precision[])');
+SELECT _postgis_drop_function_by_signature('st_quantile(raster, int, double precision[])');
+SELECT _postgis_drop_function_by_signature('st_quantile(text, text, boolean, double precision)'); -- see https://trac.osgeo.org/postgis/ticket/5579
+SELECT _postgis_drop_function_by_signature('st_quantile(text, text, double precision[])');
+SELECT _postgis_drop_function_by_signature('st_quantile(text, text, double precision)'); -- see https://trac.osgeo.org/postgis/ticket/5579
+SELECT _postgis_drop_function_by_signature('st_quantile(text, text, int, boolean, double precision[])');
 SELECT _postgis_drop_function_by_signature('_st_quantile(text, text, int, boolean, double precision, double precision[])');
--- this cannot be drop until the quantile deprecated functions are gon
+SELECT _postgis_drop_function_by_signature('st_quantile(text, text, int, boolean, double precision)'); -- see https://trac.osgeo.org/postgis/ticket/5579
+SELECT _postgis_drop_function_by_signature('st_quantile(text, text, int, double precision[])');
+SELECT _postgis_drop_function_by_signature('st_quantile(text, text, int, double precision)'); -- see https://trac.osgeo.org/postgis/ticket/5579
+-- this cannot be drop until the quantile deprecated functions are gone
 DROP TYPE IF EXISTS quantile;
 
 -- remove TYPE valuecount

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

Summary of changes:
 NEWS                                          |  3 ++-
 raster/rt_pg/rtpostgis_upgrade_cleanup.sql.in | 31 +++++++++++++++++----------
 2 files changed, 22 insertions(+), 12 deletions(-)


hooks/post-receive
-- 
PostGIS