diff options
| author | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2022-04-25 15:48:13 +0200 |
|---|---|---|
| committer | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2022-04-25 15:48:13 +0200 |
| commit | dec8ad367e46180f826d5b6dc820fbecba1b71d2 (patch) | |
| tree | 980cd742389ff86fefd54cdaf8a9e1f0bddb060e | |
| parent | 4fb5c794e58613561f94ad5ea1197729be7791dc (diff) | |
| download | postgresql-dec8ad367e46180f826d5b6dc820fbecba1b71d2.tar.gz postgresql-dec8ad367e46180f826d5b6dc820fbecba1b71d2.zip | |
Drop unlogged table after test is done
Another test is constructed on top of regression tests, which does not
work correctly with unlogged tables. For now, cope with that by making
sure no unlogged table is left behind.
Per buildfarm pink after 4fb5c794e586.
| -rw-r--r-- | src/test/regress/expected/spgist.out | 1 | ||||
| -rw-r--r-- | src/test/regress/sql/spgist.sql | 1 |
2 files changed, 2 insertions, 0 deletions
diff --git a/src/test/regress/expected/spgist.out b/src/test/regress/expected/spgist.out index 51bb9a95c5c..f07b6f0145e 100644 --- a/src/test/regress/expected/spgist.out +++ b/src/test/regress/expected/spgist.out @@ -41,6 +41,7 @@ select count(*) 3 (1 row) +drop table spgist_box_tbl; -- The point opclass's choose method only uses the spgMatchNode action, -- so the other actions are not tested by the above. Create an index using -- text opclass, which uses the others actions. diff --git a/src/test/regress/sql/spgist.sql b/src/test/regress/sql/spgist.sql index f375025dcb1..d56b80a51b6 100644 --- a/src/test/regress/sql/spgist.sql +++ b/src/test/regress/sql/spgist.sql @@ -45,6 +45,7 @@ create index spgist_box_idx on spgist_box_tbl using spgist (b); select count(*) from (values (point(5,5)),(point(8,8)),(point(12,12))) v(p) where exists(select * from spgist_box_tbl b where b.b && box(v.p,v.p)); +drop table spgist_box_tbl; -- The point opclass's choose method only uses the spgMatchNode action, -- so the other actions are not tested by the above. Create an index using |