]> git.ipfire.org Git - thirdparty/postgresql.git/commit
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)
commit840729fd104e6ff35e0a6ebcf06ad053403a96f5
tree2615426ef9672b8e7958d902212931ffd0463cce
parent1f5ef5ae0806cb75bb0297e46e41765ffa426252
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