News for hackers. Stuff that matters.

A comment on Temporal Tables PostgreSQL Extension.

Re:Temporal Tables PostgreSQL Extension by beeforpork on Sunday April 11, 2021 @06:31AM (#26769235)
Why do you need the versioning_trigger on 'INSERT' also? There is no original row to archive in this case, or what does this do?
[ Parent | on HN ]
Re:Temporal Tables PostgreSQL Extension by karavelov on Sunday April 11, 2021 @06:33AM (#26769243)
I guess they have to populate the time range column.
[ Parent | on HN ]
Re:Temporal Tables PostgreSQL Extension by jerryluc on Sunday April 11, 2021 @06:37AM (#26769268)
Probably because of:

  ON CONFLICT DO UPDATE
See: https://www.postgresql.org/docs/9.5/sql-insert.html
[ Parent | on HN ]