Hacker News new | past | comments | ask | show | jobs | submit login

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?



I guess they have to populate the time range column.


Probably because of:

  ON CONFLICT DO UPDATE
See: https://www.postgresql.org/docs/9.5/sql-insert.html




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: