[SCM] PostGIS branch stable-3.4 updated. 3.4.3-17-g3779b5ae9

[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  3779b5ae9d956a822c3712990807cd9865e9c4f8 (commit)
      from  dbbac22788b5cd2047af00a5b2bb346e22c0ee33 (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 3779b5ae9d956a822c3712990807cd9865e9c4f8
Author: Regina Obe <lr at pcorp.us>
Date:   Sun Oct 27 18:06:59 2024 -0400

    Fix typo
    Add to NEWS
    Closes #5790 for PostGIS 3.4.4

diff --git a/NEWS b/NEWS
index 66d7b91e9..534bc7fcc 100644
--- a/NEWS
+++ b/NEWS
@@ -11,6 +11,8 @@ PostGIS 3.4.4dev
   - #5795, Fix ST_NewEdgesSplit can cause invalid topology
           (Björn Harrtell
   - #5677, Retain SRID during unary union (Paul Ramsey)
+  - #5790, Non-schema qualified calls causing issue with
+           materialized views (Regina Obe)
 
 * Enhancements *
 
diff --git a/raster/rt_pg/rtpostgis.sql.in b/raster/rt_pg/rtpostgis.sql.in
index 7a144fd15..1aa234624 100644
--- a/raster/rt_pg/rtpostgis.sql.in
+++ b/raster/rt_pg/rtpostgis.sql.in
@@ -7532,7 +7532,7 @@ CREATE OR REPLACE FUNCTION _add_raster_constraint_pixel_types(rastschema name, r
 
 		sql := 'ALTER TABLE ' || fqtn
 			|| ' ADD CONSTRAINT ' || quote_ident(cn)
-			|| ' CHECK (_ at extschema@.raster_constraint_pixel_types(' || quote_ident($3)
+			|| ' CHECK (@extschema at ._raster_constraint_pixel_types(' || quote_ident($3)
 			|| ') = ''{';
 		FOR x in 1..max LOOP
 			sql := sql || '"' || attr[x] || '"';
@@ -7620,7 +7620,7 @@ CREATE OR REPLACE FUNCTION _add_raster_constraint_nodata_values(rastschema name,
 
 		sql := 'ALTER TABLE ' || fqtn
 			|| ' ADD CONSTRAINT ' || quote_ident(cn)
-			|| ' CHECK (_ at extschema@.raster_constraint_nodata_values(' || quote_ident($3)
+			|| ' CHECK (@extschema at ._raster_constraint_nodata_values(' || quote_ident($3)
 			|| ')::numeric[] = ''{';
 		FOR x in 1..max LOOP
 			IF attr[x] IS NULL THEN

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

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


hooks/post-receive
-- 
PostGIS