[postgis-tickets] [SCM] PostGIS branch stable-3.0 updated. 3.0.5-11-gab3c32563

[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.0 has been updated
       via  ab3c32563f1509d7d564e8f466ffe777a0335c6d (commit)
      from  d5d3dfe8f558485cf63037601a5dc114ca21f4e1 (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 ab3c32563f1509d7d564e8f466ffe777a0335c6d
Author: Regina Obe <lr at pcorp.us>
Date:   Sun Jul 17 19:14:28 2022 -0400

    Add cost to ST_Value. References #5154 for PostGIS 3.0.6

diff --git a/NEWS b/NEWS
index 1149e19fb..a663aefa3 100644
--- a/NEWS
+++ b/NEWS
@@ -13,6 +13,7 @@ PostGIS 3.0.6
 	- #5151, garden crash ST_SetPoint with empty geometries (Regina Obe)
   - #5150, Change signature of AddToSearchPath (Regina Obe)
   - #5155, More schema qual fixes (Regina Obe)
+  - #5154, ST_Value is undercosted (Regina Obe)
 
 PostGIS 3.0.5
 2022/02/02
diff --git a/raster/rt_pg/rtpostgis.sql.in b/raster/rt_pg/rtpostgis.sql.in
index 15414c346..7da88f48f 100644
--- a/raster/rt_pg/rtpostgis.sql.in
+++ b/raster/rt_pg/rtpostgis.sql.in
@@ -5031,12 +5031,12 @@ CREATE OR REPLACE FUNCTION St_BandFileTimestamp(rast raster, band integer DEFAUL
 CREATE OR REPLACE FUNCTION st_value(rast raster, band integer, x integer, y integer, exclude_nodata_value boolean DEFAULT TRUE)
     RETURNS float8
     AS 'MODULE_PATHNAME','RASTER_getPixelValue'
-    LANGUAGE 'c' IMMUTABLE STRICT _PARALLEL;
+    LANGUAGE 'c' IMMUTABLE STRICT _PARALLEL _COST_MEDIUM;
 
 CREATE OR REPLACE FUNCTION st_value(rast raster, x integer, y integer, exclude_nodata_value boolean DEFAULT TRUE)
     RETURNS float8
     AS $$ SELECT st_value($1, 1, $2, $3, $4) $$
-    LANGUAGE 'sql' IMMUTABLE STRICT _PARALLEL;
+    LANGUAGE 'sql' IMMUTABLE STRICT _PARALLEL _COST_MEDIUM;
 
 CREATE OR REPLACE FUNCTION st_value(rast raster, band integer, pt geometry, exclude_nodata_value boolean DEFAULT TRUE)
     RETURNS float8 AS
@@ -5064,12 +5064,12 @@ CREATE OR REPLACE FUNCTION st_value(rast raster, band integer, pt geometry, excl
                         exclude_nodata_value);
     END;
     $$
-    LANGUAGE 'plpgsql' IMMUTABLE STRICT _PARALLEL;
+    LANGUAGE 'plpgsql' IMMUTABLE STRICT _PARALLEL _COST_MEDIUM;
 
 CREATE OR REPLACE FUNCTION ST_Value(rast raster, pt geometry, exclude_nodata_value boolean DEFAULT TRUE)
     RETURNS float8
     AS $$ SELECT @extschema at .ST_value($1, 1, $2, $3) $$
-    LANGUAGE 'sql' IMMUTABLE STRICT _PARALLEL;
+    LANGUAGE 'sql' IMMUTABLE STRICT _PARALLEL _COST_MEDIUM;
 
 -----------------------------------------------------------------------
 -- ST_PixelOfValue()

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

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


hooks/post-receive
-- 
PostGIS