34.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 41.4 . The example in Section 34.4 contains a demonstration of these rules.