citusdata / citusdata/pg_shard
Warn when distributing unenforceable constraints
Open
feature
- Dominant language
- C
- Stars
- 1.1k
- Forks
- 62
- PR merge metrics
- No merged PRs in 30d
Description
Certain constraints are unenforceable in a distributed setting: `UNIQUE` indexes foremost among them. `pg_shard` will happily propagate a `UNIQUE` index with nary a peep.
The extension should either warn when propagating these constraints or refuse to distribute tables altogether which contain such constraints.
Contributor guide
Assessment
This issue has not been assessed yet.