attach_chunk()

Attach a chunk to a hypertable

Since 2.21.0

Attach a as a in another at a given slice in a dimension.

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

The syntax is:

CALL attach_chunk(
    hypertable = '<hypertable_name>',
    chunk = '<chunk_name>',
    slices = '<jsonb_slices>'
);

Name	Type	Default	Required	Description
hypertable	REGCLASS	-	✔	Name of the to attach chunk to.
chunk	REGCLASS	-	✔	Name of the to attach.
slices	JSONB	-	✔	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.