Triggers
This example creates a new table called with the same schema as conditions
, but that only stores records which are considered errors. An error, in this case, is when an application sends a temperature
or humidity
reading with a value that is greater than or equal to 1000.
TimescaleDB supports the full range of triggers, including BEFORE INSERT
, AFTER INSERT
, BEFORE UPDATE
, AFTER UPDATE
, , and AFTER DELETE
. For more information, see the PostgreSQL docs.