Horton

Fix incorrect xmlschema output for types timetz and timestamptz.

Tom Lane <tgl@sss.pgh.pa.us>

View on postgr.es
Commit: ae8ec7febac1b414681c16022e6c655a62a2540a
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2022-03-18T20:01:42Z
Releases: 14.3 
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

Files

PathChange+/−
src/backend/utils/adt/xml.c modified +2 −2
src/test/regress/expected/xmlmap_1.out modified +8 −2
src/test/regress/expected/xmlmap.out modified +496 −432
src/test/regress/sql/xmlmap.sql modified +8 −2

Discussion