|Subject||Re: Cannot restore 32GB DB - fails at end, unusable. Any ideas please.|
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.