Prevent regtest being affected by autovacuum

[pgdbmsstats/pg_dbms_stats.git] / sql / ut-common.sql

diff --git a/sql/ut-common.sql b/sql/ut-common.sql
index 5b3ac1b..a23c3dd 100644 (file)
--- a/sql/ut-common.sql
+++ b/sql/ut-common.sql
@@ -935,16 +935,22 @@ 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;
 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;
 COMMIT;
 SELECT * FROM dbms_stats.backup_history;