pgsql: Don't attempt to upgrade bpchar indexes from versions before 14.

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 attempt to upgrade bpchar indexes from versions before 14.
Date: 2026-10-07 01:17:09
Message-ID: E1xEGHN-00000000cfh-001u@gemulon.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: 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(at)bowt(dot)ie>
Reviewed-by: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Discussion: https://postgr.es/m/CAH2-Wzk-oO3HjLaByo8Vpse6Tpha1mqAW8DFShh-kS-Wo59ugA@mail.gmail.com
Backpatch-through: 14

Branch
------
REL_17_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/0fc4077f7f51a2e38924026e89862c150b784c5f

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

Browse pgsql-committers by date

  From Date Subject
Next Message Richard Guo 2026-10-07 01:30:29 Re: pgsql: Teach expr_is_nonnullable() to handle more expression types
Previous Message Tom Lane 2026-10-07 01:17:08 pgsql: Don't attempt to upgrade bpchar indexes from versions before 14.