postgres
diff --git a/‎src/test/isolation/specs/vacuum-skip-locked.spec
Copy file name to clipboardExpand all lines: src/test/isolation/specs/vacuum-skip-locked.spec
+2Lines changed: 2 additions & 0 deletions b/‎src/test/isolation/specs/vacuum-skip-locked.spec
Copy file name to clipboardExpand all lines: src/test/isolation/specs/vacuum-skip-locked.spec
+2Lines changed: 2 additions & 0 deletions
diff --git a/‎src/test/regress/expected/vacuum.out
Copy file name to clipboardExpand all lines: src/test/regress/expected/vacuum.out
+4-1Lines changed: 4 additions & 1 deletion b/‎src/test/regress/expected/vacuum.out
Copy file name to clipboardExpand all lines: src/test/regress/expected/vacuum.out
+4-1Lines changed: 4 additions & 1 deletion
diff --git a/‎src/test/regress/sql/vacuum.sql
Copy file name to clipboardExpand all lines: src/test/regress/sql/vacuum.sql
+4-1Lines changed: 4 additions & 1 deletion b/‎src/test/regress/sql/vacuum.sql
Copy file name to clipboardExpand all lines: src/test/regress/sql/vacuum.sql
+4-1Lines changed: 4 additions & 1 deletion
@@ -7,7 +7,9 @@ setup
 {
 	CREATE TABLE parted (a INT) PARTITION BY LIST (a);
 	CREATE TABLE part1 PARTITION OF parted FOR VALUES IN (1);
+	ALTER TABLE part1 SET (autovacuum_enabled = false);
 	CREATE TABLE part2 PARTITION OF parted FOR VALUES IN (2);
+	ALTER TABLE part2 SET (autovacuum_enabled = false);
 }
 
 teardown
 
@@ -196,7 +196,9 @@ ERROR:  unrecognized ANALYZE option "nonexistentarg"
 LINE 1: ANALYZE (nonexistentarg) does_not_exit;
                  ^
 -- ensure argument order independence, and that SKIP_LOCKED on non-existing
--- relation still errors out.
+-- relation still errors out.  Suppress WARNING messages caused by concurrent
+-- autovacuums.
+SET client_min_messages TO 'ERROR';
 ANALYZE (SKIP_LOCKED, VERBOSE) does_not_exist;
 ERROR:  relation "does_not_exist" does not exist
 ANALYZE (VERBOSE, SKIP_LOCKED) does_not_exist;
@@ -205,6 +207,7 @@ ERROR:  relation "does_not_exist" does not exist
 VACUUM (SKIP_LOCKED) vactst;
 VACUUM (SKIP_LOCKED, FULL) vactst;
 ANALYZE (SKIP_LOCKED) vactst;
+RESET client_min_messages;
 -- ensure VACUUM and ANALYZE don't have a problem with serializable
 SET default_transaction_isolation = serializable;
 VACUUM vactst;
 
@@ -158,14 +158,17 @@ ANALYZE (nonexistent-arg) does_not_exist;
 ANALYZE (nonexistentarg) does_not_exit;
 
 -- ensure argument order independence, and that SKIP_LOCKED on non-existing
--- relation still errors out.
+-- relation still errors out.  Suppress WARNING messages caused by concurrent
+-- autovacuums.
+SET client_min_messages TO 'ERROR';
 ANALYZE (SKIP_LOCKED, VERBOSE) does_not_exist;
 ANALYZE (VERBOSE, SKIP_LOCKED) does_not_exist;
 
 -- SKIP_LOCKED option
 VACUUM (SKIP_LOCKED) vactst;
 VACUUM (SKIP_LOCKED, FULL) vactst;
 ANALYZE (SKIP_LOCKED) vactst;
+RESET client_min_messages;
 
 -- ensure VACUUM and ANALYZE don't have a problem with serializable
 SET default_transaction_isolation = serializable;
Original file line number	Diff line number	Diff line change
`@@ -7,7 +7,9 @@ setup`
`7`	`7`	`{`
`8`	`8`	`CREATE TABLE parted (a INT) PARTITION BY LIST (a);`
`9`	`9`	`CREATE TABLE part1 PARTITION OF parted FOR VALUES IN (1);`
	`10`	`+ ALTER TABLE part1 SET (autovacuum_enabled = false);`
`10`	`11`	`CREATE TABLE part2 PARTITION OF parted FOR VALUES IN (2);`
	`12`	`+ ALTER TABLE part2 SET (autovacuum_enabled = false);`
`11`	`13`	`}`
`12`	`14`
`13`	`15`	`teardown`