Hi Postgres Community,
I wanted to ask about support for temporal tables as defined in the SQL:2011 standard. Right now, I know that we can get similar functionality using extensions like
pg_temporal , which has been really useful. But for those of us running PostgreSQL on managed platforms like AWS RDS (where adding custom extensions isn’t an option), it creates a bit of a challenge.
Here are a few questions I’d love your thoughts on:
Having native temporal table support would be a huge help for users needing built-in tools for audits, historical tracking, and meeting data compliance needs. I think adding these features natively could make PostgreSQL even more powerful and flexible for different
use cases.
I've been looking into
https://github.com/xocolatl/periods but I can't tell if its an extension or part of the regular deployment.
Thanks so much for taking the time to read this and share your insights. Looking forward to hearing what you all think!
Dave
|