HI, @jonatasdp ! Thanks a lot your team and you for triggers for each statement.
At now I try to create ones and faced with situation that columnstore (compressed hypertable) does not support triggers for each statement for deletions.
CREATE TRIGGER del_tg
AFTER DELETE ON test.some_hypertable
REFERENCING OLD TABLE AS old_table
FOR EACH STATEMENT
EXECUTE FUNCTION test.some_hypertable_tgfn()
;
SQL Error [0A000]: ERROR: DELETE triggers with transition tables not supported
Could you tell me if this functionality can be expected in the future or is it technically not possible?
Triggers for each statement for insertions and updates work well.