Hannes Dorbath <light(at)theendofthetunnel(dot)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
In response to
pgsql-hackers by date
|Next:||From: ITAGAKI Takahiro||Date: 2008-01-07 02:34:12|
|Subject: Random plan selection in DBT-3|
|Previous:||From: Tom Lane||Date: 2008-01-07 01:20:10|
|Subject: Re: OUTER JOIN performance regression remains in 8.3beta4 |
pgsql-general by date
|Next:||From: Hiroshi Saito||Date: 2008-01-07 02:34:39|
|Subject: Re: Insert returning Npgsql|
|Previous:||From: Clodoaldo||Date: 2008-01-06 19:46:33|
|Subject: Re: Performance problem. Could it be related to 8.3-beta4?|