Allow unique key constraints on non-partition keys
Open
documentation
feature
- Dominant language
- C
- Stars
- 12.8k
- Forks
- 794
- Avg merge
- 2d 14h
- Merged PRs (30d)
- 31
Description
(Maybe this shouldn't be built into Citus, and instead should be something we document.)
I think with Citus 9.2 (single-shard transactions) it's now possible to support non-partition unique columns. You might be able to maintain a local table on the master with (part_col, unique_col UNIQUE), and use transactions to update it with the remote table.
Contributor guide
Assessment
This issue has not been assessed yet.