There's a couple of things that you can do with PGs transactions that don't work... | Hacker News

Hacker News new | past | comments | ask | show | jobs | submit

login

Xylakant on Oct 2, 2013 | parent | context | favorite | on: MySQL is to SQL like MongoDB to NoSQL

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 on Oct 2, 2013 [–]

That's a rather unique feature of postgres though. Not even Oracle has DDL transactions.

jeltz on Oct 4, 2013 | [–]

PostgreSQL, Sybase, DB2, Informix, Firebird all support transactional DDL.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact