pgsql: Fix incorrect xmlschema output for types timetz and timestamptz.

Lists: pgsql-committers
From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Fix incorrect xmlschema output for types timetz and timestamptz.
Date: 2022-03-18 20:02:04
Message-ID: [email protected]
Views: Whole Thread | Raw Message | Download mbox | Resend email
Lists: pgsql-committers

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/[email protected]

Branch
------
REL_10_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/e6fd4a3daff6e9d2a5dcceeae90a4b01bf1b7645

Modified Files
--------------
src/backend/utils/adt/xml.c | 4 +-
src/test/regress/expected/xmlmap.out | 928 ++++++++++++++++++---------------
src/test/regress/expected/xmlmap_1.out | 10 +-
src/test/regress/sql/xmlmap.sql | 10 +-
4 files changed, 514 insertions(+), 438 deletions(-)