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