Re: regarding triggers

but if i have "on delete cascade" constraint,
in that case if i have a trigger which is fired in case delet happens on the table y.

i have a table x, and table y has a foreign key with "on delete cascade" constraint,

now i delete a row from x, will the trigger still be called?

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Tue 1/10/2006 9:58 PM
To: John McCawley
Cc: surabhi.ahuja; pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] regarding triggers

***********************
Your mail has been scanned by iiitb VirusWall.
***********-***********

John McCawley <nospam(at)hardgeus(dot)com> writes:
> Foreign keys do not cascade deletions.

By default, no, but there is the CASCADE option ...

regards, tom lane