Prevent regtest being affected by autovacuum

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

diff --git a/expected/ut-common.out b/expected/ut-common.out
index 24d316d..3e62efa 100644 (file)
--- a/expected/ut-common.out
+++ b/expected/ut-common.out
@@ -2117,9 +2117,12 @@ SELECT * FROM dbms_stats.backup_history;
 BEGIN;
 SELECT relation::regclass, mode
   FROM pg_locks
-  WHERE relation::regclass::text LIKE 'dbms_stats.\_%\_locked'
+  WHERE
+       (relation::regclass::text LIKE 'dbms_stats.\_%\_locked'
      OR relation::regclass::text LIKE 'dbms_stats.backup_history'
-     OR relation::regclass::text LIKE 'dbms_stats.%\_backup'
+     OR relation::regclass::text LIKE 'dbms_stats.%\_backup')
+  AND
+    mode <> 'ShareUpdateExclusiveLock'
   ORDER BY relation::regclass::text, mode;
  relation | mode 
 ----------+------
@@ -2134,9 +2137,12 @@ SELECT id, unit, comment FROM dbms_stats.purge_stats(2);
 
 SELECT relation::regclass, mode
   FROM pg_locks
-  WHERE relation::regclass::text LIKE 'dbms_stats.\_%\_locked'
+  WHERE
+       (relation::regclass::text LIKE 'dbms_stats.\_%\_locked'
      OR relation::regclass::text LIKE 'dbms_stats.backup_history'
-     OR relation::regclass::text LIKE 'dbms_stats.%\_backup'
+     OR relation::regclass::text LIKE 'dbms_stats.%\_backup')
+  AND
+    mode <> 'ShareUpdateExclusiveLock'
   ORDER BY relation::regclass::text, mode;
              relation             |       mode       
 ----------------------------------+------------------