Make the regression tests safe for TOAST.

tglsfdc · tglsfdc · commit 282713a836d5 · 2000-07-05T23:02:37.000Z
diff --git a/src/test/regress/expected/sanity_check.out b/src/test/regress/expected/sanity_check.out
@@ -1,11 +1,12 @@
 VACUUM;
 --
 -- sanity check, if we don't have indices the test will take years to
--- complete.
+-- complete.  But skip TOAST relations since they will have varying
+-- names depending on the current OID counter.
 --
 SELECT relname, relhasindex
    FROM pg_class
-   WHERE relhasindex
+   WHERE relhasindex AND relkind != 't'
    ORDER BY relname;
        relname       | relhasindex 
 ---------------------+-------------
diff --git a/src/test/regress/expected/type_sanity.out b/src/test/regress/expected/type_sanity.out
@@ -111,8 +111,7 @@ WHERE p1.typsend = p2.oid AND p1.typtype = 'b' AND
 -- Look for illegal values in pg_class fields
 SELECT p1.oid, p1.relname
 FROM pg_class as p1
-WHERE (p1.relkind != 'r' AND p1.relkind != 'i' AND
-       p1.relkind != 's' AND p1.relkind != 'S');
+WHERE p1.relkind NOT IN ('r', 'i', 's', 'S', 't');
  oid | relname 
 -----+---------
 (0 rows)
diff --git a/src/test/regress/sql/sanity_check.sql b/src/test/regress/sql/sanity_check.sql
@@ -2,10 +2,11 @@
 VACUUM;
 --
 -- sanity check, if we don't have indices the test will take years to
--- complete.
+-- complete.  But skip TOAST relations since they will have varying
+-- names depending on the current OID counter.
 --
 SELECT relname, relhasindex
    FROM pg_class
-   WHERE relhasindex
+   WHERE relhasindex AND relkind != 't'
    ORDER BY relname;
 
diff --git a/src/test/regress/sql/type_sanity.sql b/src/test/regress/sql/type_sanity.sql
@@ -99,8 +99,7 @@ WHERE p1.typsend = p2.oid AND p1.typtype = 'b' AND
 
 SELECT p1.oid, p1.relname
 FROM pg_class as p1
-WHERE (p1.relkind != 'r' AND p1.relkind != 'i' AND
-       p1.relkind != 's' AND p1.relkind != 'S');
+WHERE p1.relkind NOT IN ('r', 'i', 's', 'S', 't');
 
 -- Indexes should have an access method, others not.
 
