[Site Bug] Issue with the page: /api/latest/hypertable/create_index/ - Add limitation info about PRIMARY KEY and UNIQUE index

[igor2x]

Using "timescaledb.transaction_per_chunk" can not be created on UNIQUE index

CREATE UNIQUE INDEX myindex01 ON mytable (id) WITH (timescaledb.transaction_per_chunk);
returns error:

ERROR: cannot use timescaledb.transaction_per_chunk with UNIQUE or PRIMARY KEY

What do the docs say now?

No info provided.

What should the docs say?

Add some info like "Limitation" or "Note" rectangle info or similar that UNIQUE index is not supported.

Page affected

https://docs.timescale.com/api/latest/hypertable/create_index/

Any further info

Tested on TimescaleDB v1.18.2 on PostgreSQL v15.10 on Red Hat 9