Re: Trigger violates foreign key constraint

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