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@sss.pgh.pa.us]
Sent: Tue 1/10/2006 9:58 PM
To: John McCawley
Cc: surabhi.ahuja; pgsql-general@postgresql.org
Subject: Re: [GENERAL] regarding triggers

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


John McCawley <nospam@hardgeus.com> writes:
> Foreign keys do not cascade deletions.

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

                        regards, tom lane