citusdata / citusdata/citus

Request: Automatic trigger propagation

Open
#2,292 2 comments 0 reactions 0 assignees View on GitHub
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.