[mdellabitta]

What if you're writing a migration that includes DML, and it fails partway through? Wouldn't it be good to be able to restore the DB state automatically and try again?

[AlterEgo20]

Postgres has transactional DDL and DML. If anything fails - everything is rolled back.

[dragonwriter]

"Transnational" => "Transactional"

[AlterEgo20]

Yep. Damn auto correct.