Re: [SQL] Efficient ON DELETE trigger when referential integrity is

2002-11-12 Thread Stephan Szabo
On Tue, 12 Nov 2002, [iso-8859-1] Cédric Dufour (Cogito Ergo Soft) wrote: > Hello, > > I am trying to figure out how to handle tuple deletion efficiently when ON > DELETE triggers and referential integrity are involved. The scenario is > about this one: > > I have a MASTER and a SLAVE table, the l

[SQL] Efficient ON DELETE trigger when referential integrity is involved ?

2002-11-12 Thread Cédric Dufour
Hello,   I am trying to figure out how to handle tuple deletion efficiently when ON DELETE triggers and referential integrity are involved. The scenario is about this one:   I have a MASTER and a SLAVE table, the latter referencing the former through a "FOREIGN KEY ... REFERENCES ... ON DELET

[SQL] Efficient ON DELETE trigger when referential integrity is involved ?

2002-11-12 Thread Cédric Dufour (Cogito Ergo Soft)
Hello,   I am trying to figure out how to handle tuple deletion efficiently when ON DELETE triggers and referential integrity are involved. The scenario is about this one:   I have a MASTER and a SLAVE table, the latter referencing the former through a "FOREIGN KEY ... REFERENCES ... ON DELET