Re: [GENERAL] Index trouble with 8.3b4

2008-01-07 Thread Hannes Dorbath
Tom Lane wrote: I didn't have any luck reproducing either of these behaviors --- maybe it's data-dependent. Can you extract a test case? I will try to come up with a test case, but it might take until next weekend, sorry. The test data was an IRC log file, containing lots of color and form

Re: [GENERAL] Index trouble with 8.3b4

2008-01-07 Thread Gregory Stark
"Tom Lane" <[EMAIL PROTECTED]> writes: > I didn't have any luck reproducing either of these behaviors --- maybe > it's data-dependent. Can you extract a test case? I haven't been able to reproduce this either but I produced an entirely different problem: postgres=# create index concurrently dg5

Re: [GENERAL] Index trouble with 8.3b4

2008-01-07 Thread Gregory Stark
"Tom Lane" <[EMAIL PROTECTED]> writes: > Hannes Dorbath <[EMAIL PROTECTED]> 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

Re: [GENERAL] Index trouble with 8.3b4

2008-01-06 Thread Tom Lane
Hannes Dorbath <[EMAIL PROTECTED]> 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. > Afte