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?