Aleksander Alekseev <aleksan...@timescale.com> writes: >> 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! Hearing no further comments, done like that. regards, tom lane