Francisco Reyes wrote:
Alban Hertroys writes:I suppose you run those queries in a transaction block, right?Correct. Also I do a backup before doing the deletions.
Note that if you're in a transaction, you don't technically need the backup (doesn't hurt though) as if you get it wrong you can just roll it back.
---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster