Fix XMLTABLE() deparsing to quote namespace names if necessary.
authorDean Rasheed <dean.a.rasheed@gmail.com>
Sun, 12 Jan 2025 12:54:32 +0000 (12:54 +0000)
committerDean Rasheed <dean.a.rasheed@gmail.com>
Sun, 12 Jan 2025 12:54:32 +0000 (12:54 +0000)
commitd673eefd410cd7f5f95e418990146189f44811af
treeade6571ad31b483220b25a46f924e3ee3ddf71f4
parent29dfffae0a6db6cb880ae873169f5512ddab703d
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
src/backend/utils/adt/ruleutils.c
src/test/regress/expected/xml.out
src/test/regress/expected/xml_1.out
src/test/regress/expected/xml_2.out
src/test/regress/sql/xml.sql