7 ms·
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/T
by qianli_cs 2y ago
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 https://wiki.postgresql.org/wiki/Temporal_Extensions
Or you could use triggers to build one: https://hypirion.com/musings/implementing-system-versioned-tables-in-postgres https://hypirion.com/musings/implementing-system-versioned-t...
- baq 2y agoany 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.