PostgreSQL Bugs - Re: B-tree unique index duplicate key error happens only in SUSE 9.3

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Re: B-tree unique index duplicate key error happens only in SUSE 9.3

John Hansen

2005-06-19, 9:23 am

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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Sponsored Links