citusdata / citusdata/citus_docs
Tip for distributing tables with foreign keys
- Dominant language
- CSS
- Stars
- 58
- Forks
- 60
- PR merge metrics
- No merged PRs in 30d
Description
## Communication goals (e.g. detailed howto vs orientation)
Citus does not support adding foreign keys between local and distributed tables. It does support distributing the target table for an existing foreign key. It does not allow distributing the source table for an existing foreign key. Thus the easiest way to avoid getting tangled up in dependencies is to distribute all tables first, and add foreign keys later.
### Good locations for content in docs structure
* Update http://docs.citusdata.com/en/v7.5/develop/reference_ddl.html#adding-removing-constraints
* See whether the note needs updating in http://docs.citusdata.com/en/v7.5/develop/reference_ddl.html#distributing-coordinator-data
Contributor guide
Assessment
This issue has not been assessed yet.