[PostGIS] #5633: postgis_extensions_upgrade() breaks and signalize unbalanced parenteses in regex of regexp_replace function

[PostGIS]

#5633: postgis_extensions_upgrade() breaks and signalize unbalanced parenteses in
regex of regexp_replace function
---------------------------+-----------------------------------------------
  Reporter:  hci           |      Owner:  strk
      Type:  enhancement   |     Status:  assigned
  Priority:  low           |  Milestone:  PostGIS PostgreSQL
 Component:  upgrade/soft  |    Version:  3.3.x
Resolution:                |   Keywords:  upgrade extensions regexp_replace
---------------------------+-----------------------------------------------
Comment (by strk):

 There are a bunch of other issues with standard conforming strings off,
 like:
 {{{
 Loading PostGIS into 'postgis_reg'
 WARNING:  nonstandard use of escape in a string literal
 LINE 4:  FROM pg_catalog.substring(version(), 'PostgreSQL ([0-9\.]+)...
 }}}

 should we force them ON when installing postgis ?
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5633#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.