News for hackers. Stuff that matters.
Re:Ask HN: Best approach for manual data fixes in db? by surprisetalk on Sunday March 05, 2023 @12:54PM (#35032077)

  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.

There are no comments on this comment yet.