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@xxxxxxxxxxxxx]
Sent: Tue 1/10/2006 9:58 PM
To: John McCawley
Cc: surabhi.ahuja; pgsql-general@xxxxxxxxxxxxxx
Subject: Re: [GENERAL] regarding triggers
***********************
Your mail has been scanned by iiitb VirusWall.
***********-***********
John McCawley <nospam@xxxxxxxxxxxx> writes:
> Foreign keys do not cascade deletions.
By default, no, but there is the CASCADE option ...
regards, tom lane
