diff options
| author | Thomas Munro <tmunro@postgresql.org> | 2022-01-20 22:11:48 +1300 |
|---|---|---|
| committer | Thomas Munro <tmunro@postgresql.org> | 2022-01-20 23:31:01 +1300 |
| commit | 8e8e253a7b90d89dd9cb9d33848b55ac79958351 (patch) | |
| tree | b9619828c5a2b4756771dce5566d4f57b0267b82 /src | |
| parent | 3ca40a2b18a0638994e35160dfc8d392b1aef898 (diff) | |
| download | postgresql-8e8e253a7b90d89dd9cb9d33848b55ac79958351.tar.gz postgresql-8e8e253a7b90d89dd9cb9d33848b55ac79958351.zip | |
Try to stabilize reloptions test, again.
Since the test requires reproducible behavior from VACUUM, and since
DISABLE_PAGE_SKIPPING doesn't actually disable all forms of page
skipping, let's use a temporary table to avoid contention.
Back-patch to 12, like commit 3414099c.
Discussion: https://postgr.es/m/20220120052404.sonrhq3f3qgplpzj%40alap3.anarazel.de
Diffstat (limited to 'src')
| -rw-r--r-- | src/test/regress/expected/reloptions.out | 2 | ||||
| -rw-r--r-- | src/test/regress/sql/reloptions.sql | 2 |
2 files changed, 2 insertions, 2 deletions
diff --git a/src/test/regress/expected/reloptions.out b/src/test/regress/expected/reloptions.out index d1a17ef1d30..b6aef6f654c 100644 --- a/src/test/regress/expected/reloptions.out +++ b/src/test/regress/expected/reloptions.out @@ -89,7 +89,7 @@ ALTER TABLE reloptions_test RESET (fillfactor=12); ERROR: RESET must not include values for parameters -- Test vacuum_truncate option DROP TABLE reloptions_test; -CREATE TABLE reloptions_test(i INT NOT NULL, j text) +CREATE TEMP TABLE reloptions_test(i INT NOT NULL, j text) WITH (vacuum_truncate=false, toast.vacuum_truncate=false, autovacuum_enabled=false); diff --git a/src/test/regress/sql/reloptions.sql b/src/test/regress/sql/reloptions.sql index cf7a8a3509e..4252b0202f4 100644 --- a/src/test/regress/sql/reloptions.sql +++ b/src/test/regress/sql/reloptions.sql @@ -55,7 +55,7 @@ ALTER TABLE reloptions_test RESET (fillfactor=12); -- Test vacuum_truncate option DROP TABLE reloptions_test; -CREATE TABLE reloptions_test(i INT NOT NULL, j text) +CREATE TEMP TABLE reloptions_test(i INT NOT NULL, j text) WITH (vacuum_truncate=false, toast.vacuum_truncate=false, autovacuum_enabled=false); |