From e2aef4969450da69bc759e19f62a2d6caec4a3d9 Mon Sep 17 00:00:00 2001
From: Jan Wieck
Date: Tue, 21 Dec 1999 00:06:44 +0000
Subject: Added empty TOASTER files and corrected some minor glitches in
 regression tests.

Jan
---
 src/test/regress/expected/opr_sanity.out | 3 ++-
 src/test/regress/expected/rules.out      | 4 ++--
 src/test/regress/sql/opr_sanity.sql      | 3 ++-
 3 files changed, 6 insertions(+), 4 deletions(-)

(limited to 'src/test')

diff --git a/src/test/regress/expected/opr_sanity.out b/src/test/regress/expected/opr_sanity.out
index 96253c77511..305b67e42d6 100644
--- a/src/test/regress/expected/opr_sanity.out
+++ b/src/test/regress/expected/opr_sanity.out
@@ -3,7 +3,8 @@ FROM pg_proc as p1
 WHERE (p1.prolang = 0 OR p1.prorettype = 0 OR
     p1.pronargs < 0 OR p1.pronargs > 9)
 	AND p1.proname !~ '^pl[^_]+_call_handler$'
-	AND p1.proname !~ '^RI_FKey_';
+	AND p1.proname !~ '^RI_FKey_'
+	AND p1.proname != 'update_pg_pwd';
 oid|proname
 ---+-------
 (0 rows)
diff --git a/src/test/regress/expected/rules.out b/src/test/regress/expected/rules.out
index 5938458a88e..ccf5ffd4333 100644
--- a/src/test/regress/expected/rules.out
+++ b/src/test/regress/expected/rules.out
@@ -128,11 +128,11 @@ a| b
 2|13
 (3 rows)
 
-QUERY: delete from rtest_v1 where b = 12;
-QUERY: select * from rtest_v1;
 ** Remember the delete rule on rtest_v1: It says
 ** DO INSTEAD DELETE FROM rtest_t1 WHERE a = old.a
 ** So this time both rows with a = 2 must get deleted
+QUERY: delete from rtest_v1 where b = 12;
+QUERY: select * from rtest_v1;
 a| b
 -+--
 1|11
diff --git a/src/test/regress/sql/opr_sanity.sql b/src/test/regress/sql/opr_sanity.sql
index 8cfc8505d86..a465d26a069 100644
--- a/src/test/regress/sql/opr_sanity.sql
+++ b/src/test/regress/sql/opr_sanity.sql
@@ -28,7 +28,8 @@ FROM pg_proc as p1
 WHERE (p1.prolang = 0 OR p1.prorettype = 0 OR
     p1.pronargs < 0 OR p1.pronargs > 9)
 	AND p1.proname !~ '^pl[^_]+_call_handler$'
-	AND p1.proname !~ '^RI_FKey_';
+	AND p1.proname !~ '^RI_FKey_'
+	AND p1.proname != 'update_pg_pwd';
 
 -- Look for conflicting proc definitions (same names and input datatypes).
 
-- 
cgit v1.2.3