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
Re: Index trouble with 8.3b4 Re: Index trouble with 8.3b4 |
Список | 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 по дате отправления: