Skip to main content

max / makenotwork

260 B · 5 lines History Blame Raw
1 -- Add unique constraint on pending_s3_deletions to prevent duplicate enqueue.
2 -- ON CONFLICT DO NOTHING makes this safe for concurrent insertions.
3 CREATE UNIQUE INDEX IF NOT EXISTS idx_pending_s3_deletions_key_bucket
4 ON pending_s3_deletions (s3_key, bucket);
5