Commit8a70a1c

committed

Hmm. I didn't expect a change since I hadn't added tests for the new

stuff, but fixing the bug that existed in reporting the constraint namechanges the error line. Patch to expected output enclosed.Stephan Szabo

1 parent0d59dad commit8a70a1cCopy full SHA for 8a70a1c

File tree

-1

lines changed

-1

lines changed

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -285,7 +285,7 @@ INSERT INTO tmp3 values (5,50);`
`285`	`285`	`-- Try (and fail) to add constraint due to invalid data`
`286`	`286`	`ALTER TABLE tmp3 add constraint tmpconstr foreign key (a) references tmp2 match full;`
`287`	`287`	`NOTICE: ALTER TABLE ... ADD CONSTRAINT will create implicit trigger(s) for FOREIGN KEY check(s)`
`288`		`-ERROR:<unnamed> referential integrity violation - key referenced from tmp3 not found in tmp2`
	`288`	`+ERROR:tmpconstr referential integrity violation - key referenced from tmp3 not found in tmp2`
`289`	`289`	`-- Delete failing row`
`290`	`290`	`DELETE FROM tmp3 where a=5;`
`291`	`291`	`-- Try (and succeed)`

Comments

(0)