transaction

Groups multiple sql steps into one atomic transaction. A failure in any nested query rolls back the entire block.

Declaration

transaction "provision" {
  connection = connection.postgres.main

  sql "step_one" {
    # ...
  }

  sql "step_two" {
    # ...
  }
}

Attribute	Type	Required	Description
`label`	`string`	yes	Transaction identifier
`connection`	`connection`	yes	Pool used to acquire the transaction handle
`sql` blocks	`block`	at least one	Executed sequentially inside the transaction

Nested steps may reference each other's results in the normal way.

A query error triggers an immediate ROLLBACK.

A catch block that aborts with a status also rolls back and writes its error payload directly to the client.

If every statement succeeds, the engine issues COMMIT before continuing with the next pipeline step.

See Transactional writes for a complete example.