pgsql: Adapt pg_upgrade test to pg_lsn output format difference

From: Álvaro Herrera <alvherre(at)kurilemu(dot)de>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Adapt pg_upgrade test to pg_lsn output format difference
Date: 2025-07-07 20:39:09
Message-ID: E1uYscH-005A8K-2E@gemulon.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Adapt pg_upgrade test to pg_lsn output format difference

Commit 2633dae2e487 added some zero padding to various LSNs output
routines so that the low word is always 8 hex digits long, for easy
human consumption. This included the pg_lsn datatype, which breaks the
pg_upgrade test when it compares the pg_dump output of an older version.
Silence this problem by setting the pg_lsn columns to NULL before the
upgrade.

Discussion: https://postgr.es/m/202507071504.xm2r26u7lmzr@alvherre.pgsql

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/3adcf9fbd8ba9c07edb3ef5168a259fb12e6e3a6

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

Browse pgsql-committers by date

  From Date Subject
Next Message Jacob Champion 2025-07-07 20:40:40 pgsql: oauth: Fix kqueue detection on OpenBSD
Previous Message Tom Lane 2025-07-07 18:34:55 pgsql: Restore the ability to run pl/pgsql expression queries in parall