From 09df854b8acbba5c1d1dc5cdf30c8e84f59145e2 Mon Sep 17 00:00:00 2001 From: Kevin Grittner Date: Wed, 11 Dec 2013 08:53:03 -0600 Subject: [PATCH] Add table name to VACUUM statement in matview.c. The test only needs the one table to be vacuumed. Vacuuming the database may affect other tests. Per gripe from Tom Lane. Back-patch to 9.3, where the test was was added. --- src/test/regress/expected/matview.out | 2 +- src/test/regress/sql/matview.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/src/test/regress/expected/matview.out b/src/test/regress/expected/matview.out index 9b1f54e389..9ba2b9a7b4 100644 --- a/src/test/regress/expected/matview.out +++ b/src/test/regress/expected/matview.out @@ -391,7 +391,7 @@ SELECT * FROM hogeview WHERE i < 10; --- (0 rows) -VACUUM ANALYZE; +VACUUM ANALYZE hogeview; SELECT * FROM hogeview WHERE i < 10; i --- diff --git a/src/test/regress/sql/matview.sql b/src/test/regress/sql/matview.sql index 8d03d331cf..83fd6870d2 100644 --- a/src/test/regress/sql/matview.sql +++ b/src/test/regress/sql/matview.sql @@ -130,7 +130,7 @@ CREATE INDEX hogeviewidx ON hogeview (i); DELETE FROM hoge; REFRESH MATERIALIZED VIEW hogeview; SELECT * FROM hogeview WHERE i < 10; -VACUUM ANALYZE; +VACUUM ANALYZE hogeview; SELECT * FROM hogeview WHERE i < 10; DROP TABLE hoge CASCADE; -- 2.40.0