Troubleshooting

This section contains some ideas for troubleshooting common problems experienced with distributed hypertables.

Can’t create unique index on hypertable, or can’t create hypertable with unique index

`

1. ERROR: cannot create a unique index without the column "<COLUMN_NAME>" (used in partitioning)

`

You might get a unique index and partitioning column error in 2 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

For more information on how to fix this problem, see the section on creating unique indexes on hypertables.