Re: Index trouble with 8.3b4

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Index trouble with 8.3b4
Дата
Msg-id 1730.1199672529@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Index trouble with 8.3b4  (Hannes Dorbath <light@theendofthetunnel.de>)
Ответы Re: Index trouble with 8.3b4  (Gregory Stark <stark@enterprisedb.com>)
Re: Index trouble with 8.3b4  (Gregory Stark <stark@enterprisedb.com>)
Re: Index trouble with 8.3b4  (Hannes Dorbath <light@theendofthetunnel.de>)
Список pgsql-general
Hannes Dorbath <light@theendofthetunnel.de> writes:
> hannes=> CREATE INDEX CONCURRENTLY "ts_fts_tsv" ON "public"."fts" USING gin ("tsv");
> ERROR: item pointer (0,1) alreadt exists

> I was able to reproduce that error a few times, but not always. It seems
>   it only happens with CONCURRENTLY.

> After creating a GIST index instead of GIN I tried to cluster on that:

> hannes=> CLUSTER fts USING ts_fts_tsv;
> ERROR:  could not create unique index "pk_fts"
> DETAIL:  Table contains duplicated values.
> So duplicate values in my PK column?

I didn't have any luck reproducing either of these behaviors --- maybe
it's data-dependent.  Can you extract a test case?

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: Hannes Dorbath
Дата:
Сообщение: Index trouble with 8.3b4
Следующее
От: "Hiroshi Saito"
Дата:
Сообщение: Re: Insert returning Npgsql