I'm now trying to restore it with "ignore validity constraints" off in flamerobin.
It's a production database but this restore is for a side-project (email logging). I clearly need to get to the root of the problem. The offending index is added to using a generated integer within a trigger so it is very odd to get this error. The system has been up for 6-7 years now, 20-25 users.
