> Following reindex command failed: > db=# reindex table parts_stock_stat; > ERROR: could not create unique index > "parts_stock_stat_lower_stock_type_id_idx" > DETAIL: Key (lower(name), stock_type_id)=(ha_hr/50, 4) is duplicated.
How long have you had this database? If it's older than your last OS upgrade, it's possible that the index has become corrupt as a result of OS-level collation changes. See