"Tom Lane" <tgl@sss.pgh.pa.us> writes:
> 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.
>...
> I didn't have any luck reproducing either of these behaviors --- maybe
> it's data-dependent. Can you extract a test case?
I the GIN problem kicks in with the "posting tree" representation. That would
require more than about 85 records with the same matching lexeme-key.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL training!