indexing bug? - Mailing list pgsql-general

From Arsalan Zaidi
Subject indexing bug?
Date
Msg-id 00b601c1725c$10c099e0$4301a8c0@directi.com
Whole thread Raw
Responses Re: indexing bug?  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
Hi.

I've created around 4 indexes on a certain table and the CREATE INDEX
command succeeds. When I check for their existence through pgsql with a \d
'table_name'; they're displayed....

However, when I then try to CLUSTER them, the first cluster command runs,
but *all the other indexes disappear* ! So the rest of the cluster commands
fail. When I now do a \d on the table, I see only one index, the one I made
the first cluster on.

This happens on both 7.1.3 and 7.2b2.

Is this a known bug or am I doing something wrong? Any workarounds?

Thanks in advance.

--Arsalan

-------------------------------------------------------------------
People often hate those things which they do not know, or cannot understand.
--Ali Ibn Abi Talib (AS)


pgsql-general by date:

Previous
From: Tommi Mäkitalo
Date:
Subject: Re: migrating from MSSql
Next
From: Martijn van Oosterhout
Date:
Subject: Re: indexing bug?