What about trieggers for each statement?

TimescaleDB and PostgreSQL
1

Hi all!
I tried to create a trigger for each statement but the error occurred:

SQL Error [0A000]: ERROR: trigger with transition tables not supported on hypertables

This issue was raised on GitHub but there is no answer yet.
@jonatasdp, perhaps you have heard something from the developers on this issue?

2

Hi Denis, sadly not. First time I see the issue.

My guess it’s an issue with performance. I see James tried to bring a PR but got no where.

Let’s check if @matski can bring more details why we’re dragging it so long. It seems very convenient. Have you tried to overcome the issue with a custom function that operates over the batch of rows you want to insert, just not using the trigger concept?

3

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.