| From: | "Thomas G(dot) Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu> |
|---|---|
| To: | Keith Parks <emkxp01(at)mtcc(dot)demon(dot)co(dot)uk> |
| Cc: | Postgres Hackers List <hackers(at)postgresql(dot)org> |
| Subject: | Re: triggers regression tests. |
| Date: | 1998-01-12 04:52:01 |
| Message-ID: | 34B9A171.55BF53CA@alumni.caltech.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas G. Lockhart | 1998-01-12 04:57:55 | Re: [HACKERS] Alternate locations for databases |
| Previous Message | Vadim B. Mikheev | 1998-01-12 03:06:27 | Re: [HACKERS] [QUESTIONS] ORDER BY and nulls (fwd) |