title: Are triggers transaction?
body: <p>I have some triggers <code>BEFORE INSERT</code>, <code>AFTER DELETE</code> on a table. How do I make sure if trigger fails, then my query gets rollback?</p>
  
  <p>I mean I want to be sure, either both query and trigger work or none of them doesn't work. So are triggers transaction?</p>