Add Idempotency support to Postgres #7749
Description
New Feature / Enhancement Checklist
- I am not disclosing a vulnerability.
- I am not just asking a question.
- I have searched through existing issues.
Current Limitation
Postgres doesn't support Idempotency, mainly because it doesn't have a ttl index.
Feature / Enhancement Description
Originally discussed in #6744
Example Use Case
Filters out duplicate requests due to bad connectivity.
Alternatives / Workarounds
Clone the repo and manually edit lines that don't create/manage the _Idempotent class on Postgres. Then, manually create trigger or cron job that deletes rows on the database.
3rd Party References
Stack discusses a way to add triggers to Postgres to achieve similar functionality to Mongo ttl index.