[SCM] PostGIS branch master updated. 3.6.0rc2-197-g605727d96

[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  605727d9659a0d63f2ffdac567e742feb486b518 (commit)
      from  c6f24e9419fc0d0ee6bc73448791dfd743e9ced0 (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 605727d9659a0d63f2ffdac567e742feb486b518
Author: Regina Obe <lr at pcorp.us>
Date:   Wed Nov 12 20:00:15 2025 -0500

    FixCorruptTopoGeometryColumn revision to work for PG < 16
    
    Hex notation for bigint not supported for PG < 16
    Use actual digits instead.
    References #5983

diff --git a/topology/sql/manage/FixCorruptTopoGeometryColumn.sql.in b/topology/sql/manage/FixCorruptTopoGeometryColumn.sql.in
index ccfbc83b3..9c1ca04ec 100644
--- a/topology/sql/manage/FixCorruptTopoGeometryColumn.sql.in
+++ b/topology/sql/manage/FixCorruptTopoGeometryColumn.sql.in
@@ -49,10 +49,10 @@ WHERE pg_type.typname = 'topogeometry' AND pga.attname = 'id'
 	   %3$I = (
 	     (%3$I).topology_id,
 	    (%3$I).layer_id,
-	     ((%3$I).id & 0xFFFFFFFF)::bigint,
+	     ((%3$I).id & 4294967295 )::bigint,
 	     ((%3$I).id >> 32)::integer
 	   )::topology.topogeometry
-	 WHERE (  (%3$I).id & 0xFFFFFFFF )::bigint <> (%3$I).id OR  (  (%3$I).id >> 32 )::integer = (%3$I).type  ', layerSchema, layerTable, layerColumn);
+	 WHERE (  (%3$I).id &  4294967295 )::bigint <> (%3$I).id OR  (  (%3$I).id >> 32 )::integer = (%3$I).type  ', layerSchema, layerTable, layerColumn);
 
 	 EXECUTE var_sql;
 	 GET DIAGNOSTICS var_row_count = ROW_COUNT;

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

Summary of changes:
 topology/sql/manage/FixCorruptTopoGeometryColumn.sql.in | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)


hooks/post-receive
-- 
PostGIS