pgsql: Fix XMLTABLE() deparsing to quote namespace names if necessary. - Mailing list pgsql-committers

From Dean Rasheed
Subject pgsql: Fix XMLTABLE() deparsing to quote namespace names if necessary.
Date
Msg-id E1tWxf5-00195J-3B@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Fix XMLTABLE() deparsing to quote namespace names if necessary.

When deparsing an XMLTABLE() expression, XML namespace names were not
quoted. However, since they are parsed as ColLabel tokens, some names
require double quotes to ensure that they are properly interpreted.
Fix by using quote_identifier() in the deparsing code.

Back-patch to all supported versions.

Dean Rasheed, reviewed by Tom Lane.

Discussion: https://postgr.es/m/CAEZATCXTpAS%3DncfLNTZ7YS6O5puHeLg_SUYAit%2Bcs7wsrd9Msg%40mail.gmail.com

Branch
------
REL_17_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/61b12135f5b71df3721e8f13eab812b38c0de11f

Modified Files
--------------
src/backend/utils/adt/ruleutils.c   |  3 ++-
src/test/regress/expected/xml.out   | 10 +++++++---
src/test/regress/expected/xml_1.out |  8 +++++---
src/test/regress/expected/xml_2.out | 10 +++++++---
src/test/regress/sql/xml.sql        |  8 +++++---
5 files changed, 26 insertions(+), 13 deletions(-)


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql: Repair memory leaks in plpython.
Next
From: Dean Rasheed
Date:
Subject: pgsql: Fix JsonExpr deparsing to quote variable names in the PASSING cl