How to create TimescaleDB Hypertable with time partitioning on non unique timestamp?
I have just started to use TimescaleDB and want to create a hypertable on a table with events. Originally I thought of following the conventional pattern of: CREATE TABLE event ( id serial PRIMARY KEY, ts timestamp with time zone NOT NULL, details varchar(255) NOT NULL ); CREATE INDEX event_ts_idx on event(ts); However, when I tried to create the hypertable