[PostGIS] #5977: WARNING: nonstandard use of escape in a string literal

[PostGIS]

#5977: WARNING:  nonstandard use of escape in a string literal
--------------------------+---------------------------
 Reporter:  strk          |      Owner:  strk
     Type:  defect        |     Status:  new
 Priority:  medium        |  Milestone:  PostGIS 3.6.0
Component:  upgrade/soft  |    Version:  master
 Keywords:                |
--------------------------+---------------------------
 See https://woodie.osgeo.org/repos/30/pipeline/3431/71#L1860

 {{{
 WARNING:  nonstandard use of escape in a string literal
 LINE 4:                 '[^\d.].*',
                         ^
 HINT:  Use the escape string syntax for escapes, e.g., E'\r\n'.
 QUERY:  SELECT pg_catalog.string_to_array(
             pg_catalog.regexp_replace(
                 new_scripts,
                 '[^\d.].*',
                 ''
             ),
             '.'
         )::int[]
 }}}

 To reproduce, you need to `set standard_conforming_strings = off`

 The code is in the upgrade script, parsing the version string.

 I'm not sure how to reproduce breakage, as I suspect it takes some support
 from run_test.pl
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5977>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.