Request: Automatic trigger propagation
Open
- Dominant language
- C
- Stars
- 12.8k
- Forks
- 794
- Avg merge
- 2d 14h
- Merged PRs (30d)
- 31
Description
Currently, triggers created on reference tables do not propagate to workers on creation, and as such do not fire when corresponding actions are taken. As such, the only way to create a working trigger is to run run_command_on_workers and specify distributed table names in the trigger or function definition.
This request is for functionality to be added to allow for distributed triggers without having to directly reference shard IDs of distributed tables. Ideally, standard CREATE TRIGGER or DROP TRIGGER statements could be used in a distributed fashion.
Contributor guide
Assessment
This issue has not been assessed yet.