aboutsummaryrefslogtreecommitdiff
path: root/src
diff options
context:
space:
mode:
authorJan Wieck <JanWieck@Yahoo.com>1999-09-30 15:28:34 +0000
committerJan Wieck <JanWieck@Yahoo.com>1999-09-30 15:28:34 +0000
commitce1f5ed5472d6fb3878cfc0ee5026a3764c25b57 (patch)
treef7b7c976dd58e207adc25e7e16873635065cfc89 /src
parentccecf1fa460a934bf5d4ebaa4ef8568735cc82e0 (diff)
downloadpostgresql-ce1f5ed5472d6fb3878cfc0ee5026a3764c25b57.tar.gz
postgresql-ce1f5ed5472d6fb3878cfc0ee5026a3764c25b57.zip
Fixed opr_sanity regression test to ignore the new
RI_FKey_... constrint triggers when looking for illegal pg_proc entries. Jan
Diffstat (limited to 'src')
-rw-r--r--src/test/regress/expected/opr_sanity.out3
-rw-r--r--src/test/regress/sql/opr_sanity.sql3
2 files changed, 4 insertions, 2 deletions
diff --git a/src/test/regress/expected/opr_sanity.out b/src/test/regress/expected/opr_sanity.out
index e8ce7df9727..96253c77511 100644
--- a/src/test/regress/expected/opr_sanity.out
+++ b/src/test/regress/expected/opr_sanity.out
@@ -2,7 +2,8 @@ QUERY: SELECT p1.oid, p1.proname
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 !~ '^pl[^_]+_call_handler$'
+ AND p1.proname !~ '^RI_FKey_';
oid|proname
---+-------
(0 rows)
diff --git a/src/test/regress/sql/opr_sanity.sql b/src/test/regress/sql/opr_sanity.sql
index 454820930fb..8cfc8505d86 100644
--- a/src/test/regress/sql/opr_sanity.sql
+++ b/src/test/regress/sql/opr_sanity.sql
@@ -27,7 +27,8 @@ SELECT p1.oid, p1.proname
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 !~ '^pl[^_]+_call_handler$'
+ AND p1.proname !~ '^RI_FKey_';
-- Look for conflicting proc definitions (same names and input datatypes).