Horton

Fix XMLTABLE() deparsing to quote namespace names if necessary.

Dean Rasheed <dean.a.rasheed@gmail.com>

View on postgr.es
Commit: d673eefd410cd7f5f95e418990146189f44811af
Author: Dean Rasheed <dean.a.rasheed@gmail.com>
Date: 2025-01-12T12:54:32Z
Releases: 18.0 
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

Files

PathChange+/−
src/backend/utils/adt/ruleutils.c modified +2 −1
src/test/regress/expected/xml_1.out modified +5 −3
src/test/regress/expected/xml_2.out modified +7 −3
src/test/regress/expected/xml.out modified +7 −3
src/test/regress/sql/xml.sql modified +5 −3

Discussion