Re: B-tree unique index duplicate key error happens only in SUSE 9.3 - Mailing list pgsql-bugs

From John Hansen
Subject Re: B-tree unique index duplicate key error happens only in SUSE 9.3
Date
Msg-id 5066E5A966339E42AA04BA10BA706AE50A9355@rodrick.geeknet.com.au
Whole thread Raw
In response to B-tree unique index duplicate key error happens only in SUSE 9.3  (Zhenlei Cai <jpenguin@gmail.com>)
List pgsql-bugs
FYI, Works just fine on gentoo with the UTF8 and ICU patches.

... John

> This bug happens in SUSE 9.3 on both Pentium 4 and AMD64,=20
> whether the binaries are from  postgresql-8.0.1 RPMs on the=20
> SUSE 9.3 DVD or are built from 8.0.3 source code. However=20
> this bug does NOT happen with a Debian box (unstable) running=20
> 8.0.3 on an x86 (Athlon XP, whether binary or built from=20
> source). The problem is Postgresql claims two records has the=20
> same value for one string attribute that has a unique=20
> constraint, while in fact the two string values are=20
> different. To  see this bug, just do a restore from the=20
> pg_dump'ed file attached to this email. Sample steps and=20
> error message follow:

pgsql-bugs by date:

Previous
From: Zhenlei Cai
Date:
Subject: B-tree unique index duplicate key error happens only in SUSE 9.3
Next
From: Tom Lane
Date:
Subject: Re: B-tree unique index duplicate key error happens only in SUSE 9.3