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  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: "willie"
Дата:
Сообщение: BUG #1810: Select * From XXX where xfield = 'Chinese_String';
Следующее
От: "Chris Hoover"
Дата:
Сообщение: BUG #1809: invalid pointer on pg_ctl reload