A hypothetical job API has two servers and a PostgreSQL 18 table with a unique request identifier. The current proposal stores only that identifier and answers every uniqueness conflict with “already accepted”. Either server can encounter the conflict.
The first client times out and retries. Its payload might have changed. The first attempt might also have triggered an external action before the timeout.
ON CONFLICT DO NOTHING avoids inserting the conflicting row. It does not compare those payloads or establish the external action's outcome. Cancelling a Go request context does not prove that remote work is absent either.
What durable record would let the second server give a meaningful response? I want the review to distinguish a matching retry, changed input under the same identifier, and work whose outcome is still unknown.