NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commit57ae788

committed

Drop index behind pg_upgrade test issue.

The vacuum_cleanup_index_scale_factor storage parameter was set in abtree index that was previously left behind in the regression testdatabase. As a result, the index gets tested within pg_dump andpg_restore tests, as well as pg_upgrade testing. This won't work whenupgrading to Postgres 14, though, because the storage parameter wasremoved on that version by commit9f3665f.Fix the test failure by dropping the index in question.Per buildfarm member crake.Discussion:https://postgr.es/m/CAH2-WzmeXYBWdhF7BMhNjhq9exsk=E1ohqBFAwzPdXJZ1XDMUA@mail.gmail.comBackpatch: 11-12 only

1 parent5645a6a commit57ae788Copy full SHA for 57ae788

File tree

2 files changed

-0

lines changed

src/test/regress
- expected
  - btree_index.out
- sql
  - btree_index.sql

2 files changed

-0

lines changed

`‎src/test/regress/expected/btree_index.out`

Lines changed: 1 addition & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -312,6 +312,7 @@ select reloptions from pg_class WHERE oid = 'btree_idx1'::regclass;`
`312`	`312`	`{vacuum_cleanup_index_scale_factor=70.0}`
`313`	`313`	`(1 row)`
`314`	`314`
	`315`	`+drop index btree_idx1;`
`315`	`316`	`--`
`316`	`317`	`-- Test for multilevel page deletion`
`317`	`318`	`--`

`‎src/test/regress/sql/btree_index.sql`

Lines changed: 1 addition & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -140,6 +140,7 @@ create index btree_idx_err on btree_test(a) with (vacuum_cleanup_index_scale_fac`
`140`	`140`	`-- Simple ALTER INDEX`
`141`	`141`	`alterindex btree_idx1set (vacuum_cleanup_index_scale_factor=70.0);`
`142`	`142`	`select reloptionsfrom pg_classWHEREoid='btree_idx1'::regclass;`
	`143`	`+dropindex btree_idx1;`
`143`	`144`
`144`	`145`	`--`
`145`	`146`	`-- Test for multilevel page deletion`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

Search code, repositories, users, issues, pull requests...

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commit57ae788

File tree

2 files changed

2 files changed

`‎src/test/regress/expected/btree_index.out`

`‎src/test/regress/sql/btree_index.sql`

0 commit comments