Hi, > Perhaps we should leave the system triggers out of the discussion > entirely? More or less like: > > If a foreign key constraint specifies referential actions (that > is, cascading updates or deletes), those actions are performed via > ordinary SQL update or delete commands on the referencing table. > In particular, any triggers that exist on the referencing table > will be fired for those changes. If such a trigger modifies or > blocks the effect of one of these commands, the end result could > be to break referential integrity. It is the trigger programmer's > responsibility to avoid that.
That's perfect! -- Best regards, Aleksander Alekseev
