[SCM] PostGIS branch stable-3.3 updated. 3.3.7-52-g102a16c5d

[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.3 has been updated
       via  102a16c5df4d14f125944815e85030adf95d678e (commit)
      from  2a72650666c858e626c92afcfc4da5bc68501bbd (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 102a16c5df4d14f125944815e85030adf95d678e
Author: Paul Ramsey <pramsey at cleverelephant.ca>
Date:   Fri Sep 5 16:00:00 2025 -0700

    #5978, fix parsing of constraints in geometry_columns

diff --git a/NEWS b/NEWS
index 572696298..b4f6c67b2 100644
--- a/NEWS
+++ b/NEWS
@@ -6,6 +6,7 @@ Proj 4.9+ required.
 
 * Bug Fixes and Enhancements *
 
+ - #5978, fix parsing of constraints in geometry_columns (Paul Ramsey)
  - #5977, Fix downgrade protection with standard conforming strings off (Sandro Santilli)
  - #5951, [topology] Fix crash in ST_GetFaceEdges with corrupted topology (Sandro Santilli)
  - #5947, [topology] Fix crash in ST_ModEdgeHeal (Sandro Santilli)
diff --git a/postgis/postgis.sql.in b/postgis/postgis.sql.in
index c8629354a..bb1bad9b9 100644
--- a/postgis/postgis.sql.in
+++ b/postgis/postgis.sql.in
@@ -6306,28 +6306,28 @@ CREATE OR REPLACE VIEW geometry_columns AS
 	 LEFT JOIN ( SELECT s.connamespace,
 			s.conrelid,
 			s.conkey,
-			(regexp_match(s.consrc, E'geometrytype\(\w+\)\s*=\s*(\w+)', E'i'))[1]::text AS type
+			(regexp_match(s.consrc, $$geometrytype\(\w+\)\s*=\s*'(\w+)'$$, 'i'))[1]::text AS type
 		   FROM (SELECT connamespace, conrelid, conkey, pg_get_constraintdef(oid) As consrc
 				FROM pg_constraint) AS s
-		  WHERE s.consrc ~* E'geometrytype(\w+)\s*=\s*\w+'::text
+		  WHERE s.consrc ~* $$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, E'ndims\(\w+\)\s*=\s*(\d+)', E'i'))[1]::integer AS ndims
+			(regexp_match(s.consrc, $$ndims\(\w+\)\s*=\s*(\d+)$$, 'i'))[1]::integer AS ndims
 		   FROM (SELECT connamespace, conrelid, conkey, pg_get_constraintdef(oid) As consrc
 			FROM pg_constraint) AS s
-		  WHERE s.consrc ~* E'ndims(\w+)\s*=\s*\d+'::text
+		  WHERE s.consrc ~* $$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, E'srid\(\w+\)\s*=\s*(\d+)', E'i'))[1]::integer As srid
+			(regexp_match(s.consrc, $$srid\(\w+\)\s*=\s*(\d+)$$, 'i'))[1]::integer As srid
 		   FROM (SELECT connamespace, conrelid, conkey, pg_get_constraintdef(oid) As consrc
 			FROM pg_constraint) AS s
-		  WHERE s.consrc ~* E'srid(\w+)\s*=\s*\d+'::text
+		  WHERE s.consrc ~* $$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:
 NEWS                   |  1 +
 postgis/postgis.sql.in | 12 ++++++------
 2 files changed, 7 insertions(+), 6 deletions(-)


hooks/post-receive
-- 
PostGIS