Hacker News new | ask | show | jobs
by surprisetalk 1207 days ago

  begin;

  update example_table ...

  -- > 1 row changed

  commit;



  begin;

  update example_table ...

  -- > 1,000 rows changed

  rollback;


I know it's not exactly what you're asking, but you can use transactions to prevent "YOLO query" situations.