News for hackers. Stuff that matters.
Re:Did Pixar accidentally delete Toy Story 2 during producti... by lobster_johnson on Tuesday January 17, 2017 @04:27PM (#13421391)
One of PostgreSQL's best features is transactional DDL: You can run "drop table" etc. in a transaction and roll back afterwards. This has saved me a few times. It also makes it trivial to write atomic migration scripts: Rename a column, drop a table, update all the rows, whatever you want -- it will either all be committed or not committed at all. Surprisingly few databases support this. (Oracle doesn't, last I checked.)

There are no comments on this comment yet.