Does an AFTER UPDATE trigger happen within the original table update transaction?
Q1: If an AFTER UPDATE trigger fails, will it roll back the original table update?
Q2: My application performs a database transaction that updates entries in two different PostgreSQL tables simultaneously. I want to create a trigger that calculates some data (using information from both tables) and inserts a new entry into a log table. If I create an AFTER UPDATE trigger on one of the tables, can I assume that both tables have already been updated by the time the trigger executes?
Q2: My application performs a database transaction that updates entries in two different PostgreSQL tables simultaneously. I want to create a trigger that calculates some data (using information from both tables) and inserts a new entry into a log table. If I create an AFTER UPDATE trigger on one of the tables, can I assume that both tables have already been updated by the time the trigger executes?
