Re: triggers regression tests.

Поиск
Список
Период
Сортировка
От Thomas G. Lockhart
Тема Re: triggers regression tests.
Дата
Msg-id 34B9A171.55BF53CA@alumni.caltech.edu
обсуждение исходный текст
Список 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


В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Vadim B. Mikheev"
Дата:
Сообщение: Re: [HACKERS] Re: subselects
Следующее
От: "Thomas G. Lockhart"
Дата:
Сообщение: Re: [HACKERS] Alternate locations for databases