Re^2: PM Confessional

[Jenda]

That's why I (prettymuch always) stick the handwritten updates and deletes between BEGIN TRANSACTION and ROLLBACK and if and only if I get a sane "N rows affected" message do I select and run just the statement.

Saved my butt a few times.

[Tux]

Sane way of operating. It will also protect you fro the less obvious mistake of writing

delete from table where key > 0;

instead of

delete from table where key < 0;

which is only one key apart. I know someone else who did that.

This thread is not about errors someone else made, but I will still tell one from the recent past:

After months of preparing and exercising all the needed commands for the move of one production platform to a newer platform of a more modern architecture, someone (not in our company) issued the main "rsync" command (which also had a --delete) THE WRONG WAY AROUND and deleting two days of work. The restore from backup took 6 hours and regained 1½ day of work.