Editing TimeScale Training (section)

=== Create Hypertable ===
<pre>
SELECT create_hypertable('metrics', by_range('device_time'));
</pre>

ERROR:  cannot create a unique index without the column "device_time" (used in partitioning) </br>
HINT:  If you're creating a hypertable on a table with a primary key, ensure the partitioning column is part of the primary or composite key.

<pre>
ALTER TABLE metrics DROP CONSTRAINT metrics_pkey;
ALTER TABLE metrics ADD PRIMARY KEY (id, device_time);
SELECT create_hypertable('metrics', by_range('device_time'));
</pre>

If the existing table already has data in it then you must use the "migrate_data" option. </br>
<pre>
SELECT create_hypertable('metrics', by_range('device_time'), migrate_data => true);
</pre>