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

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 on

[BUGS] Urgent: Key constraints behaving weirdly

2003-12-18 Thread Russell Garrett
Your name : Russ Garrett Your email address : [EMAIL PROTECTED] System Configuration - Architecture (example: Intel Pentium) : P4 Xeon Operating System (example: Linux 2.0.26 ELF) : Linux 2.4.22 ELF PostgreSQL version (example: PostgreSQL-7.4)