[SCM] PostGIS branch master updated. 3.6.0beta1-17-gb624df826

[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  b624df826190f37b383324c357024b86e2fe8c66 (commit)
      from  523c7a6f08ce79495f0e4c403615b3fd88e12430 (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 b624df826190f37b383324c357024b86e2fe8c66
Author: Regina Obe <lr at pcorp.us>
Date:   Fri Aug 8 18:45:59 2025 -0400

    Drop stst_approxquantile(raster, double precision) signature
    Closes #5498 for PostGIS 3.6.0

diff --git a/NEWS b/NEWS
index b9105175a..711eef38a 100644
--- a/NEWS
+++ b/NEWS
@@ -28,6 +28,8 @@ Dapeng Wang, Zuo Chenwei from HighGo (Chinese Team)
  - #3110, GT-242, [topology] numerous topology functions that accepted integer 
           replaced with bigint versions to support both integer and bigint inputs
           (Ayo Adesugba, U.S. Census Bureau)
+ - #5498 Drop st_approxquantile(raster, double precision), wasn't usable as it triggered
+    is not unique error when used (Regina Obe)
 
 
 * New Features *
diff --git a/raster/rt_pg/rtpostgis.sql.in b/raster/rt_pg/rtpostgis.sql.in
index 9760723d2..3b2a2d4c4 100644
--- a/raster/rt_pg/rtpostgis.sql.in
+++ b/raster/rt_pg/rtpostgis.sql.in
@@ -1122,11 +1122,6 @@ CREATE OR REPLACE FUNCTION st_approxquantile(rast raster, exclude_nodata_value b
 	AS $$ SELECT ( @extschema at ._ST_quantile($1, 1, $2, 0.1, ARRAY[$3]::double precision[])).value $$
 	LANGUAGE 'sql' IMMUTABLE PARALLEL SAFE;
 
-CREATE OR REPLACE FUNCTION st_approxquantile(rast raster, quantile double precision)
-	RETURNS double precision
-	AS $$ SELECT ( @extschema at ._ST_quantile($1, 1, TRUE, 0.1, ARRAY[$2]::double precision[])).value $$
-	LANGUAGE 'sql' IMMUTABLE PARALLEL SAFE;
-
 
 -----------------------------------------------------------------------
 -- ST_ValueCount and ST_ValuePercent
diff --git a/raster/rt_pg/rtpostgis_drop.sql.in b/raster/rt_pg/rtpostgis_drop.sql.in
index 33f5ad92c..156f085df 100644
--- a/raster/rt_pg/rtpostgis_drop.sql.in
+++ b/raster/rt_pg/rtpostgis_drop.sql.in
@@ -135,11 +135,10 @@ SELECT _postgis_drop_function_by_identity('st_approxquantile', 'rastertable text
 SELECT _postgis_drop_function_by_identity('st_approxquantile', 'rastertable text, rastercolumn text, exclude_nodata_value boolean, quantile double precision','3.0');
 SELECT _postgis_drop_function_by_identity('st_approxquantile', 'rastertable text, rastercolumn text, quantile double precision','3.0');
 
-
-
 SELECT _postgis_drop_function_by_identity('st_value','rast raster, band integer, pt geometry, exclude_nodata_value boolean');
 
 SELECT _postgis_drop_function_by_signature('st_gdalopenoptions(text[])');
 
 SELECT _postgis_drop_function_by_identity('st_clip','rast raster, geom geometry, nodataval float8[], crop boolean', '3.5');
+SELECT _postgis_drop_function_by_identity('st_approxquantile', 'rast raster, quantile double precision','3.6');
 

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

Summary of changes:
 NEWS                               | 2 ++
 raster/rt_pg/rtpostgis.sql.in      | 5 -----
 raster/rt_pg/rtpostgis_drop.sql.in | 3 +--
 3 files changed, 3 insertions(+), 7 deletions(-)


hooks/post-receive
-- 
PostGIS