Troubleshooting for hypertables
You can get a unique index and partitioning column error in two situations:
- When creating a primary key or unique index on a hypertable
- When creating a hypertable from a table that already has a unique index or primary key
The error looks like this:
ERROR: cannot create a unique index without the column "<COLUMN_NAME>" (used in partitioning)
For more information on how to fix this problem, see the hypertables and unique indexes section.
Found an issue on this page?Report an issue!