Do queries executed in a Postgres trigger procedure run in the same transaction?

Question

I have a BEFORE DELETE trigger which inserts rows into another table using SPI_exec.

Do these INSERT queries run in the same transaction as the one in which the original delete is executing? Hence, will the delete and all inserts roll back or commit together?

If not, how can I make that happen?

Answer 1

Yes, everything in triggers is in the same transaction as the triggering event.

Not directly related to the question, but normally you want to put side-effects in the AFTER trigger, rather than the BEFORE trigger.