sql - Postgres avoid Trigger on delete cascade -

hello have problem trigger

i have 2 tables:

• t_mandant
• t_user_has_mandant

when delete row in t_user_has_mandant call trigger beforedeleteusermandant() need possibility ignore trigger call when delete mandant t_mandant

because t_user_has_mandant has foreign key on t_mandant on delete cascade.

im using postgres 8.4

read this page of manual.

using variable

tg_table_name

data type name; name of table caused trigger invocation.

you can determine if delete t_user_has_mandant or t_mandant.