BUG #1811: unique index problem
От | George Jansen |
---|---|
Тема | BUG #1811: unique index problem |
Дата | |
Msg-id | 20050805200451.957BFF0B15@svr2.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #1811: unique index problem
|
Список | pgsql-bugs |
The following bug has been logged online: Bug reference: 1811 Logged by: George Jansen Email address: gjansen@aflcio.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?
В списке pgsql-bugs по дате отправления: