[SCM] PostGIS branch stable-3.5 updated. 3.5.2-27-g7e23418c2

[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.5 has been updated
       via  7e23418c287b8fd31be0410688c9aa4691fbc83f (commit)
       via  324c5d343d961dbe5824fe5e18db8e38291f8ca6 (commit)
      from  9def18cd1b348febd5fdc4edf9364b7e5e1ab31f (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 7e23418c287b8fd31be0410688c9aa4691fbc83f
Author: Paul Ramsey <pramsey at cleverelephant.ca>
Date:   Tue Apr 22 12:38:44 2025 -0700

    Build fixes for Apple clang version 16.0.0

diff --git a/raster/rt_pg/rtpostgis.c b/raster/rt_pg/rtpostgis.c
index 3e24479b5..0ec8b1d6c 100644
--- a/raster/rt_pg/rtpostgis.c
+++ b/raster/rt_pg/rtpostgis.c
@@ -267,7 +267,7 @@ rt_pg_options(const char* varname)
 /*  GDAL allowed config options for VSI filesystems */
 /* ---------------------------------------------------------------- */
 
-stringlist_t *vsi_option_stringlist = NULL;
+static stringlist_t *vsi_option_stringlist = NULL;
 
 
 #if POSTGIS_GDAL_VERSION < 23
diff --git a/topology/postgis_topology.c b/topology/postgis_topology.c
index 465d8766a..7b497bc8b 100644
--- a/topology/postgis_topology.c
+++ b/topology/postgis_topology.c
@@ -52,7 +52,7 @@
  */
 PG_MODULE_MAGIC;
 
-LWT_BE_IFACE* be_iface;
+static LWT_BE_IFACE* be_iface;
 
 /*
  * Private data we'll use for this backend
@@ -75,7 +75,7 @@ struct LWT_BE_DATA_T
   int topoLoadFailMessageFlavor; /* 0:sql, 1:AddPoint */
 };
 
-LWT_BE_DATA be_data;
+static LWT_BE_DATA be_data;
 
 struct LWT_BE_TOPOLOGY_T
 {
@@ -1524,7 +1524,7 @@ cb_getNodeWithinDistance2D(const LWT_BE_TOPOLOGY *topo,
     else
     {
       lwpgwarning("liblwgeom-topo invoked 'getNodeWithinDistance2D' "
-                  "backend callback with limit=%ld and no fields",
+                  "backend callback with limit=%" LWTFMT_ELEMID " and no fields",
                   elems_requested);
       appendStringInfo(sql, "*");
     }

commit 324c5d343d961dbe5824fe5e18db8e38291f8ca6
Author: Paul Ramsey <pramsey at cleverelephant.ca>
Date:   Tue Apr 22 12:35:10 2025 -0700

    Use standard conforming strings

diff --git a/postgis/postgis.sql.in b/postgis/postgis.sql.in
index bdf9879ca..e5ee01cb6 100644
--- a/postgis/postgis.sql.in
+++ b/postgis/postgis.sql.in
@@ -6399,28 +6399,28 @@ CREATE OR REPLACE VIEW geometry_columns AS
 	 LEFT JOIN ( SELECT s.connamespace,
 			s.conrelid,
 			s.conkey,
-			(regexp_match(s.consrc, 'geometrytype\(\w+\)\s*=\s*(\w+)', 'i'))[1]::text AS type
+			(regexp_match(s.consrc, E'geometrytype\(\w+\)\s*=\s*(\w+)', E'i'))[1]::text AS type
 		   FROM (SELECT connamespace, conrelid, conkey, pg_get_constraintdef(oid) As consrc
 				FROM pg_constraint) AS s
-		  WHERE s.consrc ~* 'geometrytype(\w+)\s*=\s*\w+'::text
+		  WHERE s.consrc ~* E'geometrytype(\w+)\s*=\s*\w+'::text
 
 ) st ON st.connamespace = n.oid AND st.conrelid = c.oid AND (a.attnum = ANY (st.conkey))
 	 LEFT JOIN ( SELECT s.connamespace,
 			s.conrelid,
 			s.conkey,
-			(regexp_match(s.consrc, 'ndims\(\w+\)\s*=\s*(\d+)', 'i'))[1]::integer AS ndims
+			(regexp_match(s.consrc, E'ndims\(\w+\)\s*=\s*(\d+)', E'i'))[1]::integer AS ndims
 		   FROM (SELECT connamespace, conrelid, conkey, pg_get_constraintdef(oid) As consrc
 			FROM pg_constraint) AS s
-		  WHERE s.consrc ~* 'ndims(\w+)\s*=\s*\d+'::text
+		  WHERE s.consrc ~* E'ndims(\w+)\s*=\s*\d+'::text
 
 ) sn ON sn.connamespace = n.oid AND sn.conrelid = c.oid AND (a.attnum = ANY (sn.conkey))
 	 LEFT JOIN ( SELECT s.connamespace,
 			s.conrelid,
 			s.conkey,
-			(regexp_match(s.consrc, 'st_srid\(\w+\)\s*=\s*(\d+)', 'i'))[1]::integer As srid
+			(regexp_match(s.consrc, E'st_srid\(\w+\)\s*=\s*(\d+)', E'i'))[1]::integer As srid
 		   FROM (SELECT connamespace, conrelid, conkey, pg_get_constraintdef(oid) As consrc
 			FROM pg_constraint) AS s
-		  WHERE s.consrc ~* 'srid(\w+)\s*=\s*\d+'::text
+		  WHERE s.consrc ~* E'srid(\w+)\s*=\s*\d+'::text
 
 ) sr ON sr.connamespace = n.oid AND sr.conrelid = c.oid AND (a.attnum = ANY (sr.conkey))
   WHERE (c.relkind = ANY (ARRAY['r'::"char", 'v'::"char", 'm'::"char", 'f'::"char", 'p'::"char"]))

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

Summary of changes:
 postgis/postgis.sql.in      | 12 ++++++------
 raster/rt_pg/rtpostgis.c    |  2 +-
 topology/postgis_topology.c |  6 +++---
 3 files changed, 10 insertions(+), 10 deletions(-)


hooks/post-receive
-- 
PostGIS