Commitce1f5ed

Jan Wieck

authored and

Jan Wieck

committed

Fixed opr_sanity regression test to ignore the new

RI_FKey_... constrint triggers when looking for illegalpg_proc entries.Jan

1 parentccecf1f commitce1f5edCopy full SHA for ce1f5ed

File tree

-2

lines changed

-2

lines changed

Lines changed: 2 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -2,7 +2,8 @@ QUERY: SELECT p1.oid, p1.proname`
`2`	`2`	`FROM pg_proc as p1`
`3`	`3`	`WHERE (p1.prolang = 0 OR p1.prorettype = 0 OR`
`4`	`4`	`p1.pronargs < 0 OR p1.pronargs > 9)`
`5`		`-AND p1.proname !~ '^pl[^_]+_call_handler$';`
	`5`	`+AND p1.proname !~ '^pl[^_]+_call_handler$'`
	`6`	`+AND p1.proname !~ '^RI_FKey_';`
`6`	`7`	`oid\|proname`
`7`	`8`	`---+-------`
`8`	`9`	`(0 rows)`

Lines changed: 2 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -27,7 +27,8 @@ SELECT p1.oid, p1.proname`
`27`	`27`	`FROM pg_procas p1`
`28`	`28`	`WHERE (p1.prolang=0ORp1.prorettype=0OR`
`29`	`29`	`p1.pronargs<0ORp1.pronargs>9)`
`30`		`-ANDp1.proname !~'^pl[^_]+_call_handler$';`
	`30`	`+ANDp1.proname !~'^pl[^_]+_call_handler$'`
	`31`	`+ANDp1.proname !~'^RI_FKey_';`
`31`	`32`
`32`	`33`	`-- Look for conflicting proc definitions (same names and input datatypes).`
`33`	`34`

Comments

(0)