[nierman]

you can also take advantage of transactions:

  begin;
  delete from product where id = 123;
  --verify things are correct with counts, by issuing "selects", etc.

and then issue either a "rollback;" or a "commit;"... I've been happy to have followed this pattern on occasion ;)