Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit09df854

Browse files
committed
Add table name to VACUUM statement in matview.c.
The test only needs the one table to be vacuumed. Vacuuming thedatabase may affect other tests.Per gripe from Tom Lane. Back-patch to 9.3, where the test waswas added.
1 parente5dc4cc commit09df854

File tree

2 files changed

+2
-2
lines changed

2 files changed

+2
-2
lines changed

‎src/test/regress/expected/matview.out

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -391,7 +391,7 @@ SELECT * FROM hogeview WHERE i < 10;
391391
---
392392
(0 rows)
393393

394-
VACUUM ANALYZE;
394+
VACUUM ANALYZE hogeview;
395395
SELECT * FROM hogeview WHERE i < 10;
396396
i
397397
---

‎src/test/regress/sql/matview.sql

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -130,7 +130,7 @@ CREATE INDEX hogeviewidx ON hogeview (i);
130130
DELETEFROM hoge;
131131
REFRESH MATERIALIZED VIEW hogeview;
132132
SELECT*FROM hogeviewWHERE i<10;
133-
VACUUM ANALYZE;
133+
VACUUM ANALYZE hogeview;
134134
SELECT*FROM hogeviewWHERE i<10;
135135
DROPTABLE hoge CASCADE;
136136

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp