Disalbe autovacuum during regression test

[pgdbmsstats/pg_dbms_stats.git] / expected / ut-10.out

diff --git a/expected/ut-10.out b/expected/ut-10.out
index 8d501dc..228396f 100644 (file)
--- a/expected/ut-10.out
+++ b/expected/ut-10.out
@@ -2415,7 +2415,7 @@ SELECT count(*) FROM dbms_stats.column_stats_locked;
      0
 (1 row)
 
-CREATE TABLE s1.st0(id integer, num integer);
+CREATE TABLE s1.st0(id integer, num integer) WITH (autovacuum_enabled = 'false');
 INSERT INTO s1.st0 VALUES (1, 15), (2, 25), (3, 35), (4, 45);
 VACUUM ANALYZE;
 -- No.9-1-16
@@ -9958,7 +9958,7 @@ BEGIN
 END;
 $$ LANGUAGE plpgsql;
 SET pg_dbms_stats.use_locked_stats TO on;
-CREATE TABLE s0.st4 (a text);
+CREATE TABLE s0.st4 (a text) WITH (autovacuum_enabled = 'false');
 INSERT INTO s0.st4 SELECT '1' || md5(g::text) FROM generate_series(1, 10000) as g;
 VACUUM ANALYZE s0.st4;
 -- should estimate that rows = 1, not 5000
@@ -9998,7 +9998,7 @@ SELECT dbms_stats.clean_up_stats();
 /*
  * No.15-2 Ditto for index stats
  */
-CREATE TABLE s0.st4 (a double precision);
+CREATE TABLE s0.st4 (a double precision) WITH (autovacuum_enabled = 'false');
 CREATE INDEX on s0.st4 (floor(log(a)));
 SELECT dbms_stats.lock_table_stats('s0.st4');
  lock_table_stats 
@@ -10037,7 +10037,7 @@ SELECT dbms_stats.clean_up_stats();
 
 -- No.16 error description. -- abnormal case.
 RESET SESSION AUTHORIZATION;
-CREATE TABLE s0.st4 (a int, b text);
+CREATE TABLE s0.st4 (a int, b text) WITH (autovacuum_enabled = 'false');
 CREATE VIEW s0.vst4 AS select * FROM s0.st4;
 GRANT SELECT ON s0.vst4 TO regular_user;
 ALTER TABLE dbms_stats.relation_stats_locked OWNER TO regular_user;
@@ -10063,7 +10063,7 @@ SELECT CURRENT_USER;
  super_user
 (1 row)
 
-CREATE TABLE s0.st4 (a int, b text);
+CREATE TABLE s0.st4 (a int, b text) WITH (autovacuum_enabled = 'false');
 CREATE INDEX i_st4_a on s0.st4 (a);
 CREATE VIEW s0.vst4 AS select * FROM s0.st4;
 GRANT SELECT ON s0.vst4 TO regular_user;