News for hackers. Stuff that matters.
Re:Total security in a PostgreSQL database by sonnym on Sunday February 09, 2014 @01:37PM (#7206499)
Alex at The Daily WTF wrote a great article on this subject.

http://thedailywtf.com/Articles/Database-Changes-Done-Right....

Re:Total security in a PostgreSQL database by penguindev on Sunday February 09, 2014 @10:45PM (#7208981)
That's a decent read, but unfortunately even running the same precisely-versioned and ordered change scripts against dev, test, prod dbs can produce divergent results depending on the data in the db at the time. For example, prod could have a null somewhere, or data using a different url encoding flavor.... etc.

(Or if you're really lucky, even the current load on the database could make it fail... i.e. transaction serialization failure due to the random row order you attempted to lock)

So it should have ended with 'you're doomed'.