Skip to content

Use Timescale Distributed 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

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

Keywords

distributed hypertable foreign keys Timescale Managed Service for TimescaleDB self-hosted TimescaleDB

Found an issue on this page?

Report an issue!

PreviousAlter and drop distributed hypertables NextUse triggers in distributed hypertables