pgsql: Don't request pretty-printed output from xmlNodeDump().

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Don't request pretty-printed output from xmlNodeDump().
Date: 2019-04-23 14:51:13
Message-ID: E1hIwlN-00041I-Ck@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Don't request pretty-printed output from xmlNodeDump().

xml.c passed format = 1 to xmlNodeDump(), resulting in sometimes getting
extra whitespace (newlines + spaces) in the output. We don't really want
that, first because whitespace might be semantically significant in some
XML uses, and second because it happens only very inconsistently. Only
one case in our regression tests is affected.

This potentially affects the results of xpath() and the XMLTABLE construct,
when emitting nodeset values.

Note that the older code in contrib/xml2 doesn't do this; it seems
to have been an aboriginal bad decision in commit ea3b212fe.

While this definitely seems like a bug to me, the small number of
complaints to date argues against back-patching a behavioral change.
Hence, fix in HEAD only, at least for now.

Per report from Jean-Marc Voillequin.

Discussion: https://postgr.es/m/1EC8157EB499BF459A516ADCF135ADCE3A23A9CA@LON-WGMSX712.ad.moodys.net

Branch
------
master

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

Modified Files
--------------
src/backend/utils/adt/xml.c | 2 +-
src/test/regress/expected/xml.out | 9 +++------
src/test/regress/expected/xml_2.out | 9 +++------
3 files changed, 7 insertions(+), 13 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2019-04-23 16:25:34 pgsql: Avoid order-of-execution problems with ALTER TABLE ADD PRIMARY K
Previous Message Amit Langote 2019-04-23 07:44:50 Re: pgsql: Allow insert and update tuple routing and COPY for foreign table