[postgis-tickets] [SCM] PostGIS branch master updated. 3.3.0beta2-4-g2c221417c

[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  2c221417ce749663b904f42dba0f7293b5747898 (commit)
      from  2d342e6c6a0ee3d7c807dcb1b0284e1363bef698 (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 2c221417ce749663b904f42dba0f7293b5747898
Author: Regina Obe <lr at pcorp.us>
Date:   Mon Jul 18 18:00:03 2022 -0400

    raster ST_Value is undercosted Closes #5154 for PostGIS 3.3.0

diff --git a/NEWS b/NEWS
index 2b44731f7..3d1fb4f92 100644
--- a/NEWS
+++ b/NEWS
@@ -7,6 +7,7 @@ Requires SFCGAL 1.4.1+ for ST_AlphaShape and ST_OptimalAlphaShape.
 
 Changes since PostGIS 3.3.0beta2:
 * Bug fixes *
+  - #5154, raster ST_Value is undercosted (Regina Obe)
 
 
 
diff --git a/raster/rt_pg/rtpostgis.sql.in b/raster/rt_pg/rtpostgis.sql.in
index 02de3390a..0726acf51 100644
--- a/raster/rt_pg/rtpostgis.sql.in
+++ b/raster/rt_pg/rtpostgis.sql.in
@@ -4615,17 +4615,17 @@ CREATE OR REPLACE FUNCTION st_value(rast raster, band integer, x integer, y inte
 CREATE OR REPLACE FUNCTION st_value(rast raster, band integer, pt geometry, exclude_nodata_value boolean DEFAULT TRUE, resample text DEFAULT 'nearest')
 	RETURNS float8
 	AS 'MODULE_PATHNAME', 'RASTER_getPixelValueResample'
-	LANGUAGE 'c' IMMUTABLE STRICT PARALLEL SAFE;
+	LANGUAGE 'c' IMMUTABLE STRICT PARALLEL SAFE _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::integer, $2, $3, $4) $$
-    LANGUAGE 'sql' IMMUTABLE STRICT PARALLEL SAFE;
+    LANGUAGE 'sql' IMMUTABLE STRICT PARALLEL SAFE _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::integer, $2, $3, 'nearest'::text) $$
-    LANGUAGE 'sql' IMMUTABLE STRICT PARALLEL SAFE;
+    LANGUAGE 'sql' IMMUTABLE STRICT PARALLEL SAFE _COST_MEDIUM;
 
 -- Availability: 3.2.0 added resample arg
 CREATE OR REPLACE FUNCTION st_setz(rast raster, geom geometry, resample text DEFAULT 'nearest', band integer default 1)

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

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


hooks/post-receive
-- 
PostGIS