Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                

pgsql: Ignore hash's relallvisible when checking pg_upgrade from pre-v1 - Mailing list pgsql-committers

From Tom Lane
Subject pgsql: Ignore hash's relallvisible when checking pg_upgrade from pre-v1
Date
Msg-id E1tmHSq-000L5L-2a@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Ignore hash's relallvisible when checking pg_upgrade from pre-v10.

Our cross-version upgrade tests have been failing for some pre-v10
source versions since commit 1fd1bd871.  This turns out to be
because relallvisible may change for tables that have hash indexes,
because the upgrade process forcibly reindexes such indexes to
deal with the changes made in v10.

Fortunately, the set of tables that have such indexes is small
and won't change anymore in those branches.  So just hack up
AdjustUpgrade.pm to not compare the relallvisible values of
those specific tables.

While here, also tighten the regex that suppresses comparison
of version fields.

Discussion: https://postgr.es/m/812817.1740277228@sss.pgh.pa.us

Branch
------
master

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

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


pgsql-committers by date:

Previous
From: Peter Eisentraut
Date:
Subject: pgsql: backend libpq void * argument for binary data
Next
From: Tom Lane
Date:
Subject: Re: pgsql: Trial fix for old cross-version upgrades.