6 ms·
No word that PostgreSQL 19 introduces native application-time temporal data support based on the SQL:2011 standard? https://www.depesz.com/2026/04/02/waiting-fo
by mkurz 3mo ago
No word that PostgreSQL 19 introduces native application-time temporal data support based on the SQL:2011 standard? https://www.depesz.com/2026/04/02/waiting-for-postgresql-19-add-update-delete-for-portion-of/ https://www.depesz.com/2026/04/02/waiting-for-postgresql-19-...
- m_w_ 3mo agoNor more than a mention of Query Hints, which had some interesting discussion under a similarly-titled submission. https://news.ycombinator.com/item?id=48413655 https://news.ycombinator.com/item?id=48413655
- unfocso 3mo agoWow. Incredible how this was not mentioned in the OP. I had done it with tcn triggers and adding "_archive" shadown tables manually with tcn (https://www.postgresql.org/docs/current/tcn.html https://www.postgresql.org/docs/current/tcn.html), but doing it natively is gonna be, as per most postgresql implementations, wonderful.
- mickeyp 3mo agoThey're a cool feature but honestly a bit tricky to use well, IMHO. And be careful with PII lingering in a temporal void somewhere for a long time :-)