triggers and FK cascades - Mailing list pgsql-general

From Grzegorz Jaśkiewicz
Subject triggers and FK cascades
Date
Msg-id AANLkTimowwWdLGbvCbCMn7-2=Xnsgm2T5Zqqq6mu4-tq@mail.gmail.com
Whole thread Raw
Responses Re: triggers and FK cascades  ("David Johnston" <polobo@yahoo.com>)
List 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 by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Windows ODBC connection trouble? ISP issue?
Next
From: "MauMau"
Date:
Subject: Re: Is PostgreSQL supported on RHEL6?