[postgis-tickets] [SCM] PostGIS branch master updated. 3.4.0rc1-697-g01eed3748

[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  01eed3748c0995d31c9d8fb9f3f2b5120dfab3b4 (commit)
      from  5a8528e775d15538898d6483c81052ca1df72607 (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 01eed3748c0995d31c9d8fb9f3f2b5120dfab3b4
Author: Sandro Santilli <strk at kbt.io>
Date:   Tue Oct 17 23:19:59 2023 +0200

    Properly drop st_quantile signatures deprecated in 3.1
    
    References #5579 in master branch (3.5.0dev)

diff --git a/raster/rt_pg/rtpostgis_upgrade_cleanup.sql.in b/raster/rt_pg/rtpostgis_upgrade_cleanup.sql.in
index 3f7ed38b7..3d75f71c0 100644
--- a/raster/rt_pg/rtpostgis_upgrade_cleanup.sql.in
+++ b/raster/rt_pg/rtpostgis_upgrade_cleanup.sql.in
@@ -277,28 +277,31 @@ 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, double precision)', '3.1.0'); -- See https://trac.osgeo.org/postgis/ticket/5578
 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, integer, 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, 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, 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[])');
+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;
 

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

Summary of changes:
 raster/rt_pg/rtpostgis_upgrade_cleanup.sql.in | 31 +++++++++++++++------------
 1 file changed, 17 insertions(+), 14 deletions(-)


hooks/post-receive
-- 
PostGIS