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
distributed_exec to first create the
refererenced table on all nodes.
- Create the referenced table on the access node.
distributed_execto 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.
Found an issue on this page?Report an issue!