Forum OpenACS Q&A: Response to Transactions in PL/PgSQL ?

Collapse
Posted by Tom Jackson on

I think what I am lead to believe by these statements is that, for instance, if I call a function, all the dml gets executed, or rolled back? If a sql statement inserts data into one table, which fires a trigger which inserts data into another table, will the whole thing rollback if the second insert fails? I actually have two levels of triggers in one case, where the second insert fires a second trigger which updates a third table.