35.2. Visibility of Data Changes

If you execute SQL commands in your trigger function, and these commands access the table that the trigger is for, then you need to be aware of the data visibility rules, because they determine whether these SQL commands will see the data change that the trigger is fired for. Briefly:

Further information about data visibility rules can be found in Section 42.4. The example in Section 35.4 contains a demonstration of these rules.