[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
Resolution:                |   Keywords:
---------------------------+---------------------------
Comment (by strk):

 I've pushed a branch 5977-standard-conforming-strings-in-upgrade to have
 bots check it.

 There seem to be only woodie setting `standard_conforming_strings = off`
 during upgrade, and indeed it's where we see the problem

 > .woodpecker/regress.yml:      --after-create-db-script
 $${CI_WORKSPACE}/regress/hooks/standard-conforming-strings-off.sql"

 I guess it only affects the downgrade protection and NONE of our CI is
 testing for downgrade protection
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5977#comment:1>
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.