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)
commit88ae77588d9a891c492f8ba543b3c1064c7a8ef3
treeac4c576da46eb79284b9b0d41203d3ff802f4892
parent5e144cc89b468d845a2dbd7bdd1786c6efcdfd83
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