diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out --- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2024-10-30 10:42:20.060647000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out 2024-10-30 10:44:00.790983000 +0000 @@ -77,7 +77,6 @@ Partition key: RANGE (a) Indexes: "idxpart_a_idx" btree (a) - "idxpart_a_idx1" UNIQUE, btree (a) INVALID Number of partitions: 3 (Use \d+ to list them.) \d idxpart1 @@ -91,7 +90,6 @@ Partition key: RANGE (a) Indexes: "idxpart1_a_idx" btree (a) - "idxpart1_a_idx1" UNIQUE, btree (a) INVALID Number of partitions: 1 (Use \d+ to list them.) \d idxpart11 @@ -105,7 +103,6 @@ Partition key: RANGE (a) Indexes: "idxpart11_a_idx" btree (a) - "idxpart11_a_idx1" UNIQUE, btree (a) INVALID Number of partitions: 1 (Use \d+ to list them.) \d idxpart111 @@ -119,7 +116,6 @@ Partition key: RANGE (a) Indexes: "idxpart111_a_idx" btree (a) - "idxpart111_a_idx1" UNIQUE, btree (a) INVALID Number of partitions: 1 (Use \d+ to list them.) \d idxpart1111 @@ -133,7 +129,6 @@ Partition key: RANGE (a) Indexes: "idxpart1111_a_idx" btree (a) - "idxpart1111_a_idx1" UNIQUE, btree (a) INVALID Number of partitions: 0 \d idxpart2 @@ -146,7 +141,6 @@ Partition of: idxpart FOR VALUES FROM (10) TO (20) Indexes: "idxpart2_a_idx" btree (a) - "idxpart2_a_idx1" UNIQUE, btree (a) INVALID \d idxpart3 Partitioned table "public.idxpart3" @@ -159,7 +153,6 @@ Partition key: RANGE (a) Indexes: "idxpart3_a_idx" btree (a) - "idxpart3_a_idx1" UNIQUE, btree (a) INVALID Number of partitions: 1 (Use \d+ to list them.) \d idxpart31 @@ -172,7 +165,6 @@ Partition of: idxpart3 DEFAULT Indexes: "idxpart31_a_idx" btree (a) - "idxpart31_a_idx1" UNIQUE, btree (a) INVALID drop table idxpart; -- Verify bugfix with query on indexed partitioned table with no partitions