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

From Hannes Dorbath
Subject Re: Index trouble with 8.3b4
Date
Msg-id 478B3D1A.6020205@theendofthetunnel.de
Whole thread Raw
In response to Re: Index trouble with 8.3b4  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Index trouble with 8.3b4  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:
> I've committed a patch to do that.  Please test CVS HEAD and see if you
> still see problems.

I'm happy to hear you found something and I will try CVS HEAD in a minute.

In the meantime let me report that the cluster issue happens with GIST 
as well. I have load 5 million rows in that table and did:

test=# CREATE INDEX CONCURRENTLY "ts_test_tsv_gist" ON "public"."test" 
USING gist ("tsv");
CREATE INDEX
test=# CLUSTER test USING ts_test_tsv_gist;
ERROR:  could not create unique index "test_pkey"
DETAIL:  Table contains duplicated values.
test=#

But as far as I understood this is already covered by your thesis.


-- 
Best regards,
Hannes Dorbath


pgsql-hackers by date:

Previous
From:
Date:
Subject: Using tapes on tuplesort.c
Next
From: Gregory Stark
Date:
Subject: Re: Index trouble with 8.3b4