Re: Index trouble with 8.3b4

Hannes Dorbath wrote:
> Guillaume Smet wrote:
>> On Jan 13, 2008 7:50 PM, Hannes Dorbath <light(at)theendofthetunnel(dot)de>
>> wrote:
>>> I started from scratch to put up a test case. I cannot trigger "ERROR:
>>> item pointer (0,1) already exists" again as the deadlock issue reported
>>> by Gregory Stark hit me every time. Is this fixed in RC1? Can I retry
>>> with that?
>>
>> No, it's not fixed in RC1. You have to compile CVS HEAD to have it fixed.
>
> OK, the deadlock is gone. I can only provoke it when issuing the create
> index statement from 2 terminals at the same time. But I think this is
> intended. I keep trying to catch the gin error though.

Well, or maybe not really intended that way. Both terminals error out with:

ERROR: relation "ts_test_tsv" already exists

But the index was created.

ERROR: relation "ts_test_tsv" already exists
test=# drop INDEX ts_test_tsv ;
DROP INDEX

--
Best regards,
Hannes Dorbath