diff options
| author | Kevin Grittner <kgrittn@postgresql.org> | 2013-12-11 08:53:03 -0600 |
|---|---|---|
| committer | Kevin Grittner <kgrittn@postgresql.org> | 2013-12-11 08:53:03 -0600 |
| commit | 09df854b8acbba5c1d1dc5cdf30c8e84f59145e2 (patch) | |
| tree | e7084f7a9a180d89c3a004c87f2b78beec0a5fa3 | |
| parent | e5dc4cc24d2e1e94ac572a2c64103710bf15d21e (diff) | |
| download | postgresql-09df854b8acbba5c1d1dc5cdf30c8e84f59145e2.tar.gz postgresql-09df854b8acbba5c1d1dc5cdf30c8e84f59145e2.zip | |
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.
| -rw-r--r-- | src/test/regress/expected/matview.out | 2 | ||||
| -rw-r--r-- | 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 9b1f54e389b..9ba2b9a7b48 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 8d03d331cff..83fd6870d27 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; |