Re: Index trouble with 8.3b4 - Mailing list pgsql-hackers

From Hannes Dorbath
Subject Re: Index trouble with 8.3b4
Date
Msg-id 478A6B0D.4050509@theendofthetunnel.de
Whole thread Raw
In response to Re: Index trouble with 8.3b4  (Hannes Dorbath <light@theendofthetunnel.de>)
Responses Re: Index trouble with 8.3b4
List pgsql-hackers
Hannes Dorbath wrote:
> Guillaume Smet wrote:
>> On Jan 13, 2008 7:50 PM, Hannes Dorbath <light@theendofthetunnel.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


pgsql-hackers by date:

Previous
From: "Guillaume Smet"
Date:
Subject: Re: Index trouble with 8.3b4
Next
From: Hannes Dorbath
Date:
Subject: Re: Index trouble with 8.3b4