Oh how I wish for Postgres to introduce system-versioned (bi-temporal) tables.

qianli_cs · 2024-09-26T17:43:44 1727372624

What's your use case for system-versioned tables? You could use some extensions like Periods that support bi-temporal tables: https://wiki.postgresql.org/wiki/Temporal_Extensions

Or you could use triggers to build one: https://hypirion.com/musings/implementing-system-versioned-t...

baq · 2024-09-26T21:02:13 1727384533

any system of record has a requirement to be bitemporal, it just isn't discovered until too late IME. I don't know if there's a system anywhere which conciously decided to not be bitemporal during initial design.

jeltz · 2024-09-26T18:00:39 1727373639

It will hopefully be in PostgreSQL 18.

infamia · 2024-09-27T00:07:23 1727395643

Is there an active effort to get temporal tables into Postgres at the moment?

infamia · 2024-09-28T03:18:10 1727493490

It looks like Paul A. Jungwirth and others are trying to get Temporal Tables into Postgres 18.

https://illuminatedcomputing.com/posts/2024/07/temporal-reve...