add-concurrent-xact-to-pg_surgery-test.patch
text/x-diff
Filename: add-concurrent-xact-to-pg_surgery-test.patch
Type: text/x-diff
Part: 0
Patch
Format: unified
| File | + | − |
|---|---|---|
| contrib/pg_surgery/expected/heap_surgery.out | 6 | 0 |
| contrib/pg_surgery/expected/sleep.out | 6 | 0 |
| contrib/pg_surgery/Makefile | 1 | 1 |
| contrib/pg_surgery/sql/heap_surgery.sql | 2 | 0 |
| contrib/pg_surgery/sql/sleep.sql | 1 | 0 |
| contrib/pg_surgery/surgery_schedule | 1 | 0 |
diff --git a/contrib/pg_surgery/Makefile b/contrib/pg_surgery/Makefile index a66776c4c4..a7bcfca0fb 100644 --- a/contrib/pg_surgery/Makefile +++ b/contrib/pg_surgery/Makefile @@ -9,7 +9,7 @@ EXTENSION = pg_surgery DATA = pg_surgery--1.0.sql PGFILEDESC = "pg_surgery - perform surgery on a damaged relation" -REGRESS = heap_surgery +REGRESS = --schedule=surgery_schedule ifdef USE_PGXS PG_CONFIG = pg_config diff --git a/contrib/pg_surgery/expected/heap_surgery.out b/contrib/pg_surgery/expected/heap_surgery.out index d4a757ffa0..6ef5597e7c 100644 --- a/contrib/pg_surgery/expected/heap_surgery.out +++ b/contrib/pg_surgery/expected/heap_surgery.out @@ -1,4 +1,10 @@ create extension pg_surgery; +select pg_sleep(0.1); -- ensure concurrent transaction is ready + pg_sleep +---------- + +(1 row) + -- create a normal heap table and insert some rows. -- use a temp table so that vacuum behavior doesn't depend on global xmin create temp table htab (a int); diff --git a/contrib/pg_surgery/expected/sleep.out b/contrib/pg_surgery/expected/sleep.out new file mode 100644 index 0000000000..208e31163d --- /dev/null +++ b/contrib/pg_surgery/expected/sleep.out @@ -0,0 +1,6 @@ +select pg_sleep(1.0); -- long enough for whole heap_surgery test + pg_sleep +---------- + +(1 row) + diff --git a/contrib/pg_surgery/sql/heap_surgery.sql b/contrib/pg_surgery/sql/heap_surgery.sql index 6526b27535..212c657f3c 100644 --- a/contrib/pg_surgery/sql/heap_surgery.sql +++ b/contrib/pg_surgery/sql/heap_surgery.sql @@ -1,5 +1,7 @@ create extension pg_surgery; +select pg_sleep(0.1); -- ensure concurrent transaction is ready + -- create a normal heap table and insert some rows. -- use a temp table so that vacuum behavior doesn't depend on global xmin create temp table htab (a int); diff --git a/contrib/pg_surgery/sql/sleep.sql b/contrib/pg_surgery/sql/sleep.sql new file mode 100644 index 0000000000..a85c25bca2 --- /dev/null +++ b/contrib/pg_surgery/sql/sleep.sql @@ -0,0 +1 @@ +select pg_sleep(1.0); -- long enough for whole heap_surgery test diff --git a/contrib/pg_surgery/surgery_schedule b/contrib/pg_surgery/surgery_schedule new file mode 100644 index 0000000000..1bb3aa5e53 --- /dev/null +++ b/contrib/pg_surgery/surgery_schedule @@ -0,0 +1 @@ +test: heap_surgery sleep