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

From: Zhenlei Cai <jpenguin(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: B-tree unique index duplicate key error happens only in SUSE 9.3
Date: 2005-06-19 12:16:10
Message-ID: 7035af305061905167710afc4@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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:

-------- begin command ---------------
createdb -E utf8 pg_bug
psql pg_bug < pg_dup_key_bug.dump
NOTICE: CREATE TABLE / UNIQUE will create implicit index
"gaocanusers_userid_key" for table "gaocanusers"
CREATE TABLE
ERROR: duplicate key violates unique constraint "gaocanusers_userid_key"
CONTEXT: COPY gaocanusers, line 2: "129406 ���ズ�
27324923(at)nowhere(dot)com(dot)kk f U\N \N \N \N -- f
2002-09-12 00:00:00 \N \\3031\\3..."

----------- end ------------

Attachment Content-Type Size
pg_dup_key_bug.dump application/octet-stream 1.6 KB

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message John Hansen 2005-06-19 14:05:07 Re: B-tree unique index duplicate key error happens only in SUSE 9.3
Previous Message Chii-Tung Liu 2005-06-19 11:25:59 BUG #1721: mutiple bytes character string comaprison error