[SCM] PostGIS branch master updated. 3.7.0alpha1-32-ga5411841b

[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  a5411841bd4b063d4c7ca6e371e14eaae61af85a (commit)
      from  fabbc2cc36bd515fc8299597c2ad2af74deffff0 (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 a5411841bd4b063d4c7ca6e371e14eaae61af85a
Author: Darafei Praliaskouski <me at komzpa.net>
Date:   Tue Jul 7 15:07:59 2026 +0400

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

diff --git a/NEWS b/NEWS
index 15ac2f4d8..e3e6a72a6 100644
--- a/NEWS
+++ b/NEWS
@@ -7,6 +7,8 @@ To take advantage of all postgis_sfcgal extension features SFCGAL 2.3+ is needed
 
 * Bug Fixes *
 
+ - #6094, [upgrade] Avoid legacy string literal warnings in downgrade checks
+          with standard_conforming_strings off (Darafei Praliaskouski)
  - GH-898, Fix ST_DFullyWithin indexed plans and large-coordinate
           ring-orientation precision regressions (Darafei Praliaskouski)
  - GH-1143, [topology] Clean up TopoRingIsCCW early returns
diff --git a/utils/create_upgrade.pl b/utils/create_upgrade.pl
index b10ecc61e..22d24a52d 100644
--- a/utils/create_upgrade.pl
+++ b/utils/create_upgrade.pl
@@ -1028,11 +1028,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

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

Summary of changes:
 NEWS                    | 2 ++
 utils/create_upgrade.pl | 8 ++++----
 2 files changed, 6 insertions(+), 4 deletions(-)


hooks/post-receive
-- 
PostGIS