Triggers and rules - Mailing list pgsql-general

From Mihai Gheorghiu
Subject Triggers and rules
Date
Msg-id 000f01c14859$44012720$6e646464@New6.Travel
Whole thread Raw
List pgsql-general
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.


pgsql-general by date:

Previous
From: "Dinesh Parikh"
Date:
Subject: Dynamic Query problem
Next
From: "Ben-Nes Yonatan"
Date:
Subject: boolean query