Self-hosted TimescaleDBDistributed hypertables

Create foreign keys in a distributed hypertable

Tables and values referenced by a distributed hypertable must be present on the access node and all data nodes. To create a foreign key from a distributed hypertable, use distributed_exec to first create the referenced table on all nodes.

Creating foreign keys in a distributed hypertable

  1. Create the referenced table on the access node.
  2. Use distributed_exec to create the same table on all data nodes and update it with the correct data.
  3. Create a foreign key from your distributed hypertable to your referenced table.

Keywords

distributed hypertableforeign keys

Found an issue on this page?

Report an issue!
PreviousAlter and drop distributed hypertablesNextUse triggers in distributed hypertables

Related Content

Distributed hypertables
Distributed hypertables help you horizontally scale your data storage in multi-node clusters
Query data in distributed hypertables
How to query data in distributed hypertables
Insert data
How to insert data into distributed hypertables
Use triggers on distributed hypertables
How to set up triggers on a distributed hypertable
About distributed hypertables
Learn how distributed hypertables work in multi-node Timescale
Create distributed hypertables
Create a distributed hypertable in a multi-node Timescale instance