Postgres 'undo' without restoring the whole DB — anyone tried this?

pgEdge wrote about undoing a bad change in Postgres (the classic UPDATE without WHERE) without doing a full point-in-time restore and losing everything else that happened since. For those running Postgres behind a web app, what's your actual recovery plan when someone fat-fingers prod?