3 ms·

There's a couple of things that you can do with PGs transactions that don't work in MySQL, for example transactions around DDL statements. That can leave you wi

There's a couple of things that you can do with PGs transactions that don't work in MySQL, for example transactions around DDL statements. That can leave you with quite a mess at your hand when you have to rollback half a database migration.

jhh 13y ago
That's a rather unique feature of postgres though. Not even Oracle has DDL transactions.
- jeltz 13y ago
  PostgreSQL, Sybase, DB2, Informix, Firebird all support transactional DDL.