Triggers and rules
Started by Mihai Gheorghiuover 24 years ago1 messagesgeneral
A table has TRIGGER BEFORE UPDATE, TRIGGER AFTER UPDATE and RULE ON UPDATE.
1. What is the order these three are executed?
2. Are the actions of one of them visible to the following ones, or they all
refer strictly to the record before update? E.g.: If the TRIGGER BEFORE
UPDATE changes a value in the new record, is this visible to the RULE and to
the TRIGGER AFTER UPDATE?
Thank you all.