Troubleshooting for hypertables

Unique indexes and primary keys

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

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!


Related Content