citusdata / citusdata/citus_docs

Tip for distributing tables with foreign keys

Open
#751 1 comment 0 reactions 0 assignees View on GitHub
SE
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

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.