3 ms·

What does it do when a table that already has that trigger on it gets altered (i.e. a new column is added)?

• vbilopav 2y ago
  It's already built into code to check does trigger exists, check it out. As far as changes(alter table ) goes, I need to take history tables into consideration when writing migration scripts. Since I'm doing my migrations always with SQL scripts that not an issue. However, there's a concept of system event triggers in PostgreSQL that can intercept alter table statements, so I'm thinking to expand my solution to alter history tables automatically. Check it out: https://www.postgresql.org/docs/current/event-triggers.html https://www.postgresql.org/docs/current/event-triggers.html