[SCM] PostGIS branch stable-3.2 updated. 3.2.10-62-g2294770eb

[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.2 has been updated
       via  2294770eb30ed519d5030f085a19826d034e9dd1 (commit)
      from  15dea64b4c6e3f2de45fe59c856625d4ce4771a2 (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 2294770eb30ed519d5030f085a19826d034e9dd1
Author: Darafei Praliaskouski <me at komzpa.net>
Date:   Tue Jul 7 15:09:07 2026 +0400

    upgrade: escape version regex literals
    
    Use explicit escape string syntax for the version parsing regular expressions emitted by postgis_proc_upgrade.pl. This keeps downgrade checks quiet and parser-stable when standard_conforming_strings is off.
    
    Closes #6094 for PostGIS 3.2
    
    Closes https://github.com/postgis/postgis/pull/1158

diff --git a/NEWS b/NEWS
index 8c9af9a35..833e39991 100644
--- a/NEWS
+++ b/NEWS
@@ -3,6 +3,8 @@ PostGIS 3.2.11
 
 * Bug Fixes *
 
+ - #6094, [upgrade] Avoid legacy string literal warnings in downgrade checks
+   with standard_conforming_strings off (Darafei Praliaskouski)
  - #5899, pg_upgrade issue for non-standard geography SRID (Paul Ramsey)
  - Flatgeobuf schema mismatch vulnerability (NeuroWinter)
  - #5989, CurvePolygon distance corner case (Paul Ramsey)
diff --git a/utils/postgis_proc_upgrade.pl b/utils/postgis_proc_upgrade.pl
index a75a06587..b26125cd7 100755
--- a/utils/postgis_proc_upgrade.pl
+++ b/utils/postgis_proc_upgrade.pl
@@ -728,7 +728,7 @@ BEGIN
         new_ver_int := pg_catalog.string_to_array(
             pg_catalog.regexp_replace(
                 new_scripts,
-                '[^\d.].*',
+                E'[^\\d.].*',
                 ''
             ),
             '.'
@@ -741,7 +741,7 @@ BEGIN
         old_ver_int := pg_catalog.string_to_array(
             pg_catalog.regexp_replace(
                 old_scripts,
-                '[^\d.].*',
+                E'[^\\d.].*',
                 ''
             ),
             '.'
@@ -777,11 +777,11 @@ BEGIN
     ) SELECT
       upgraded as scripts_upgraded,
       installed as scripts_installed,
-      pg_catalog.substring(upgraded, '([0-9]+)\.')::int * 100 +
-      pg_catalog.substring(upgraded, '[0-9]+\.([0-9]+)(\.|$)')::int
+      pg_catalog.substring(upgraded, E'([0-9]+)\\.')::int * 100 +
+      pg_catalog.substring(upgraded, E'[0-9]+\\.([0-9]+)(\\.|$)')::int
         as version_to_num,
-      pg_catalog.substring(installed, '([0-9]+)\.')::int * 100 +
-      pg_catalog.substring(installed, '[0-9]+\.([0-9]+)(\.|$)')::int
+      pg_catalog.substring(installed, E'([0-9]+)\\.')::int * 100 +
+      pg_catalog.substring(installed, E'[0-9]+\\.([0-9]+)(\\.|$)')::int
         as version_from_num,
       installed ~ 'dev|alpha|beta'
         as version_from_isdev
@@ -816,4 +816,3 @@ BEGIN
 END
 $$
 LANGUAGE 'plpgsql';
-

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

Summary of changes:
 NEWS                          |  2 ++
 utils/postgis_proc_upgrade.pl | 13 ++++++-------
 2 files changed, 8 insertions(+), 7 deletions(-)


hooks/post-receive
-- 
PostGIS