What changes to a table cannot be detected by a trigger?

From: Phillip Diffley <pdiffleygit(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: What changes to a table cannot be detected by a trigger?
Date: 2023-10-01 13:35:31
Message-ID: CAKd=3qGsBSYqnu8H0FrGz11+xBkx+1y-Y24ONn8AebQMVrYBhA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Triggers can be set for insert, update, delete, and truncate operations.
Alter table operations, like adding or dropping a column from a table, do
not cause an update trigger to fire but can be captured by an event trigger.

Are there any situations where the data in a table can be changed and the
change cannot be detected by a trigger or event trigger?

Thanks,
Phillip

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2023-10-01 14:32:33 Re: cache lookup failed for function 0
Previous Message Ann Harrison 2023-10-01 09:30:39 Re: Gradual migration from integer to bigint?