pgsql: Fix cross-version upgrades with XMLSERIALIZE(NO INDENT)

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Fix cross-version upgrades with XMLSERIALIZE(NO INDENT)
Date: 2025-02-21 11:38:16
Message-ID: E1tlRMH-000SVG-2d@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Fix cross-version upgrades with XMLSERIALIZE(NO INDENT)

Dumps from versions older than v16 do not know about NO INDENT in a
XMLSERIALIZE() clause. This commit adjusts AdjustUpgrade.pm so as NO
INDENT is discarded in the contents of the new dump adjusted for
comparison when the old version is v15 or older. This should be enough
to make the cross-version upgrade tests pass.

Per report from buildfarm member crake. Oversight in 984410b92326.

Reviewed-by: Andrew Dunstan <andrew(at)dunslane(dot)net>
Discussion: https://postgr.es/m/88b183f1-ebf9-4f51-9144-3704380ccae7@dunslane.net
Backpatch-through: 16

Branch
------
REL_16_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/514d47dfb69caec14b62b294f899b2e953cc2baa

Modified Files
--------------
src/test/perl/PostgreSQL/Test/AdjustUpgrade.pm | 6 ++++++
1 file changed, 6 insertions(+)

Browse pgsql-committers by date

  From Date Subject
Next Message Andrew Dunstan 2025-02-21 14:51:12 Re: pgsql: Transfer statistics during pg_upgrade.
Previous Message Peter Eisentraut 2025-02-21 11:30:24 pgsql: Support text position search functions with nondeterministic col