Hannes Dorbath <light@xxxxxxxxxxxxxxxxxxxx> 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
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
