triggers and FK cascades

Поиск
Список
Период
Сортировка
От Grzegorz Jaśkiewicz
Тема triggers and FK cascades
Дата
Msg-id AANLkTimowwWdLGbvCbCMn7-2=Xnsgm2T5Zqqq6mu4-tq@mail.gmail.com
обсуждение исходный текст
Ответы Re: triggers and FK cascades  ("David Johnston" <polobo@yahoo.com>)
Список pgsql-general
Considering the following example.
Tables A and B.
Table A contains some data.
Table B reefers to table A using FK with 'on delete cascade'. Table B
has a trigger on it, after delete per row

Now, is there any way I can tell in the trigger on table B that it has
been called from a direct delete on that table, as oppose to the
indirect (FK) delete on table A?

Trigger is PLpg/SQL or C function.


--
GJ

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Windows ODBC connection trouble? ISP issue?
Следующее
От: "MauMau"
Дата:
Сообщение: Re: Is PostgreSQL supported on RHEL6?