News for hackers. Stuff that matters.

A comment on How I Fired Myself. Parent comment

Re:How I Fired Myself by mst on Wednesday February 27, 2013 @12:27PM (#5293551)
Any CREATE, ALTER or DROP on mysql does an implicit, silent COMMIT (not rollback) before running it.

PostgreSQL can do DDL inside a transaction though.

[ Parent | on HN ]
Re:How I Fired Myself by MBCook on Wednesday February 27, 2013 @12:48PM (#5293697)
Yep, that's another one to watch out for. But I'm used to that, it's when an update or delete that can't be reversed I get surprised.
[ Parent | on HN ]