pgsql: Don't attempt to upgrade bpchar indexes from versions before 14. - Mailing list pgsql-committers

From Tom Lane
Subject pgsql: Don't attempt to upgrade bpchar indexes from versions before 14.
Date
Msg-id E1xEGHN-00000000cfn-0HeN@gemulon.postgresql.org
Whole thread
List pgsql-committers
Don't attempt to upgrade bpchar indexes from versions before 14.

As of a32b8dc98 and friends, amcheck will complain about bpchar
indexes that claim to allow de-duplication.  This causes our
cross-version-upgrade tests to fail when upgrading from a version
that lacks those commits, since there are some such indexes in the
core regression tests.  Drop such indexes from the upgrade source
database.  (oidvector indexes would be problematic too, but
there aren't any user-defined indexes on oidvector in our tests.)

Author: Peter Geoghegan <pg@bowt.ie>
Reviewed-by: Tom Lane <tgl@sss.pgh.pa.us>
Discussion: https://postgr.es/m/CAH2-Wzk-oO3HjLaByo8Vpse6Tpha1mqAW8DFShh-kS-Wo59ugA@mail.gmail.com
Backpatch-through: 14

Branch
------
REL_14_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/415cd3bfb4c08eae7b6faf9fa1c83eed2ab6f43f

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


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql: Don't attempt to upgrade bpchar indexes from versions before 14.
Next
From: Michael Paquier
Date:
Subject: pgsql: reindexdb: Forbid index-level REINDEX with CONCURRENTLY and mult