Tom Lane wrote:
> "Russell Garrett" <[EMAIL PROTECTED]> writes:
>> last=> reindex index profile_pkey;
>> ERROR: could not create unique index
>> DETAIL: Table contains duplicated values.
>
> Okay, it looks like the table actually contains duplicate rows but the
> index has managed to lose track o
"Russell Garrett" <[EMAIL PROTECTED]> writes:
> last=> reindex index profile_pkey;
> ERROR: could not create unique index
> DETAIL: Table contains duplicated values.
Okay, it looks like the table actually contains duplicate rows but the
index has managed to lose track of that fact. You can see
>> 2. The index is corrupt, possibly due to a hardware glitch. (This
>> seems unlikely because the SELECT result appears normal, but I can't
>> rule it out entirely.)
>
> We had a table error a few weeks back, however we re-imported the
> table from scratch. So it may well be this. I doubt it's a
Tom Lane wrote:
> "Russell Garrett" <[EMAIL PROTECTED]> writes:
>> Constraints are being weird. The reproduction instructions speak for
>> themselves.
>
> You haven't really provided enough info to let anyone do anything
> about this. Certainly no one else is going to be able to reproduce
> the pr
"Russell Garrett" <[EMAIL PROTECTED]> writes:
> Constraints are being weird. The reproduction instructions speak for
> themselves.
You haven't really provided enough info to let anyone do anything about
this. Certainly no one else is going to be able to reproduce the
problem based on what you've