Skip to main content
Since 2.21.0 Attach a as a in another at a given slice in a dimension. Hypertable structure The schema, name, existing constraints, and indexes of chunk do not change, even if a constraint conflicts with a constraint in hypertable. The hypertable you attach chunk to does not need to have the same dimension columns as the you previously detached chunk from. While attaching chunk to hypertable:
  • Dimension columns in chunk are set as NOT NULL.
  • Any foreign keys in hypertable are created in chunk.
You cannot:
  • Attaching a that is still attached to another . First call detach_chunk.
  • Attaching foreign tables are not supported.

​
Samples

Attach a as a in another for a specific slice in a dimension: 
CALL attach_chunk('ht', '_timescaledb_internal._hyper_1_2_chunk', '{"device_id": [0, 1000]}');

​
Arguments

NameTypeDefaultRequiredDescription
hypertableREGCLASS-✔Name of the to attach chunk to.
chunkREGCLASS-✔Name of the to attach.
slicesJSONB-✔The slice chunk will occupy in hypertable. slices cannot clash with the slice already occupied by an existing in hypertable.

​
Returns

This function returns void.