Re: triggers regression tests.

Are we sure the new expected/triggers.out is correct?

No.

The query..

QUERY: insert into fkeys values (70, '5', 1);
and
QUERY: insert into fkeys values (70, '5', 1);

should be triggering...

QUERY: create trigger check_fkeys_pkey_exist
before insert or update on fkeys
for each row
execute procedure
check_primary_key ('fkey1', 'fkey2', 'pkeys', 'pkey1', 'pkey2');

and failing because 70 does not exist in pkeys.

I think the old triggers.out was correct.

Keith.

BTW the results I'm getting now check OK against the old expected out file.
(CVS snapshot about 2 hours ago.)

Well, I'll try with a fresh snapshot. Don't know why I'm getting a different
result...

- Tom