search

timescale / timescaledb

An open-source time-series SQL database optimized for fast ingest and complex queries. Packaged as a PostgreSQL extension.
https://www.timescale.com/
Other
16.83k stars 852 forks source link

Disallow hash partitioning on primary column #6993

Closed nikkhils closed 1 month ago

nikkhils commented 1 month ago

The new "create_hypertable" API using the dimension info inadvertantly allowed creating hypertables with hash partitioning on the primary column. Since the rest of the machinery (policies, tiering, etc.) does not support hash partitions on primary column properly, we restrict it now in the new API. The older "create_hypertable" API was disallowing it earlier anyways.

fabriziomello commented 1 month ago

@nikkhils I think this should be part of 2.15.2, right?

nikkhils commented 1 month ago

@nikkhils I think this should be part of 2.15.2, right?

Yup. Added the label.