From: | "George Jansen" <gjansen(at)aflcio(dot)org> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #1811: unique index problem |
Date: | 2005-08-05 20:04:51 |
Message-ID: | 20050805200451.957BFF0B15@svr2.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 1811
Logged by: George Jansen
Email address: gjansen(at)aflcio(dot)org
PostgreSQL version: 8.0.3
Operating system: RedHat ES 4
Description: unique index problem
Details:
Importing a database in preparation for a Lyris cutover, I received an error
creating a unique index. In psql I checked the table:
lyris=# CREATE UNIQUE INDEX ix_uniquewords_word ON uniquewords_ USING btree
(word_);
ERROR: could not create unique index
DETAIL: Table contains duplicated values.
lyris=# SELECT word_, Count(*)
lyris-# FROM uniquewords_
lyris-# GROUP BY word_
lyris-# HAVING Count(*) > 1;
word_ | count
-------+-------
(0 rows)
lyris=#
Then I listed the words out in order to a text file
and ran
-bash-3.00$ uniq -c uwords | grep -v "^ *1"
2 avendano
2 espanol
-bash-3.00$
Both old and new databases use SQL_ASCII. Is this a bug?
From | Date | Subject | |
---|---|---|---|
Next Message | Donald Bahari | 2005-08-05 22:04:00 | BUG #1812: installation |
Previous Message | willie | 2005-08-05 18:28:42 | BUG #1810: Select * From XXX where xfield = 'Chinese_String'; |