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
Список 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 по дате отправления: