[PostGIS] #2808: Installing newer topology than version of PostGIS gives misleading upgrade message

[PostGIS]

#2808: Installing newer topology than version of PostGIS gives misleading upgrade
message
-----------------------+---------------------------
  Reporter:  robe      |      Owner:  strk
      Type:  defect    |     Status:  reopened
  Priority:  low       |  Milestone:  PostGIS 3.7.0
 Component:  topology  |    Version:  master
Resolution:            |   Keywords:
-----------------------+---------------------------
Changes (by robe):

 * milestone:  PostGIS Fund Me => PostGIS 3.7.0
 * resolution:  fixed =>
 * status:  closed => reopened

Comment:

 Getting error on woodie, which runs with standard_conforming_strings set
 to false.

 https://woodie.osgeo.org/repos/30/pipeline/4511/13
 {{{
 sql:/woodpecker/src/gitea.osgeo.org/postgis/postgis/build/pg14/regress/00
 -regress-install/share/contrib/postgis/postgis.sql:3210: WARNING:
 nonstandard use of escape in a string literal
 LINE 9:    '^([0-9]+)\.([0-9]+)\.([0-9]+)(dev|alpha|beta|rc)?([0-9]*...
            ^
 HINT:  Use the escape string syntax for escapes, e.g., E'\r\n'.
 psql:/woodpecker/src/gitea.osgeo.org/postgis/postgis/build/pg14/regress/00
 -regress-install/share/contrib/postgis/postgis.sql:3210: WARNING:
 nonstandard use of escape in a string literal
 LINE 9:    '^([0-9]+)\.([0-9]+)\.([0-9]+)(dev|alpha|beta|rc)?([0-9]*...
            ^
 HINT:  Use the escape string syntax for escapes, e.g., E'\r\n'.
  failed (Warnings encountered loading
 /woodpecker/src/gitea.osgeo.org/postgis/postgis/build/pg14/regress/00
 -regress-install/share/contrib/postgis/postgis.sql:
 /tmp/pgis_reg/regress_log.tmp)
 -----------------------------------------------------------------------------
 NOTICE:  schema "public" already exists, skipping
 psql:/woodpecker/src/gitea.osgeo.org/postgis/postgis/build/pg14/regress/00
 -regress-install/share/contrib/postgis/postgis.sql:3210: WARNING:
 nonstandard use of escape in a string literal
 LINE 9:    '^([0-9]+)\.([0-9]+)\.([0-9]+)(dev|alpha|beta|rc)?([0-9]*...
            ^
 HINT:  Use the escape string syntax for escapes, e.g., E'\r\n'.
 psql:/woodpecker/src/gitea.osgeo.org/postgis/postgis/build/pg14/regress/00
 -regress-install/share/contrib/postgis/postgis.sql:3210: WARNING:
 nonstandard use of escape in a string literal
 LINE 9:    '^([0-9]+)\.([0-9]+)\.([0-9]+)(dev|alpha|beta|rc)?([0-9]*...
            ^
 HINT:  Use the escape string syntax for escapes, e.g., E'\r\n'.
 -----------------------------------------------------------------------------
 make: ***
 [/woodpecker/src/gitea.osgeo.org/postgis/postgis/regress/runtest.mk:24:
 check-regress] Error
 }}}
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/2808#comment:5>
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.