diff options
author | Jan Wieck <JanWieck@Yahoo.com> | 1999-09-30 15:28:34 +0000 |
---|---|---|
committer | Jan Wieck <JanWieck@Yahoo.com> | 1999-09-30 15:28:34 +0000 |
commit | ce1f5ed5472d6fb3878cfc0ee5026a3764c25b57 (patch) | |
tree | f7b7c976dd58e207adc25e7e16873635065cfc89 /src | |
parent | ccecf1fa460a934bf5d4ebaa4ef8568735cc82e0 (diff) | |
download | postgresql-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.out | 3 | ||||
-rw-r--r-- | src/test/regress/sql/opr_sanity.sql | 3 |
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). |