citusdata / citusdata/citus

Allow unique key constraints on non-partition keys

Open
#720 3 comments 0 reactions 0 assignees View on GitHub
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

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.