Fix incorrect xmlschema output for types timetz and timestamptz.
authorTom Lane <tgl@sss.pgh.pa.us>
Fri, 18 Mar 2022 20:01:42 +0000 (16:01 -0400)
committerTom Lane <tgl@sss.pgh.pa.us>
Fri, 18 Mar 2022 20:01:42 +0000 (16:01 -0400)
commit068739fb4f345c8c922d72f2c8e15e9c0a75056d
treec3f7233bb26850cfae89ea450875dd8d858c2374
parent0d3aaadd324e0566820c863d4617eb4fc949d220
Fix incorrect xmlschema output for types timetz and timestamptz.

The output of table_to_xmlschema() and allied functions includes
a regex describing valid values for these types ... but the regex
was itself invalid, as it failed to escape a literal "+" sign.

Report and fix by Renan Soares Lopes.  Back-patch to all
supported branches.

Discussion: https://postgr.es/m/7f6fabaa-3f8f-49ab-89ca-59fbfe633105@me.com
src/backend/utils/adt/xml.c
src/test/regress/expected/xmlmap.out
src/test/regress/expected/xmlmap_1.out
src/test/regress/sql/xmlmap.sql