Re: [BUGS] Urgent: Key constraints behaving weirdly

2003-12-19 Thread Russell Garrett
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

Re: [BUGS] Urgent: Key constraints behaving weirdly

2003-12-18 Thread Tom Lane
"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

Re: [BUGS] Urgent: Key constraints behaving weirdly

2003-12-18 Thread Russell Garrett
>> 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

Re: [BUGS] Urgent: Key constraints behaving weirdly

2003-12-18 Thread Russell Garrett
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

Re: [BUGS] Urgent: Key constraints behaving weirdly

2003-12-18 Thread Tom Lane
"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