Now I know the values in the field in question are unique – I have only 3 records.

But when I delete all the records from the table, I still get the above message.

<SL> Are there other active connections?  Have they committed all transactions?

<SL> FB Indexes contain information for **all active transactions**, so if there are active transactions which can still see the old data … adding the new constraint would fail.