Wanted a daily report that sends exactly once, through restarts and two replicas.
Didn't build a scheduler check. Built a row.
Insert the date, let the unique constraint reject the losers. The insert is the lock.
Exactly once is a claim someone wins, not a clock you trust.