title: what happens to after trigger actions, when a table fails in insert actions that trigger these trigger functions?
body: <p>When I insert a row into a table X, then it will trigger another trigger function to insert a row into another table Y. </p>
  
  <p>But if the first insert fails, then what happens to the other trigger functions?<br>
  Do these trigger functions work or not?<br>
  I want to ask this for before trigger too?<br>
  If the before trigger on X table fails while inserting a row into table Y, then does the  insert into table X work or not?</p>