On 11/04/2013 11:44 AM, Jason Long wrote:
> I would like for corresponding records in t_a to be deleted when I
> delete a record from t_b. This deletes from t_b when I delete from t_a,
> but not the other way around. I am unable to create a foreign key
> constraint on t_a because this table holds records from several other
> tables. I added a simple script below that demonstrates my problem.
As I sent my previous post, it dawned on me what I think you where
trying to say. That the id field has values that have relevance to
tables other than t_b and would not be accepted by a FK to ta_b. In
other words what you are looking for is a conditional FK relationship
between t_a and t_b. AFAIK to get that you will have to roll your own
trigger on t_b.
--
Adrian Klaver
adrian.klaver@gmail.com