docs icon indicating copy to clipboard operation
docs copied to clipboard

[Content Bug] reorder_chunk requires index schema

Open igor2x opened this issue 1 year ago • 0 comments

At the bottom of documentation reorder_chunk command there is Sample usage in this sample there is text: SELECT reorder_chunk('_timescaledb_internal._hyper_1_10_chunk', 'conditions_device_id_time_idx');

I tried executing this command and got: "ERROR: relation "my_chunk_index" does not exist." Adding index schema to the index and command works fine. So sample should be changed to: SELECT reorder_chunk('_timescaledb_internal._hyper_1_10_chunk', '_timescaledb_internal.conditions_device_id_time_idx');

I have tested this on:

  • Red Hat 8.9
  • PostgreSQL v15.6
  • TimescaleDB v2.14.2

igor2x avatar Mar 26 '24 09:03 igor2x