indexing bug?

From: "Arsalan Zaidi" <azaidi(at)directi(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: indexing bug?
Date: 2001-11-21 07:13:44
Message-ID: 00b601c1725c$10c099e0$4301a8c0@directi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tommi Mäkitalo 2001-11-21 07:20:27 Re: migrating from MSSql
Previous Message Andrew G. Hammond 2001-11-21 05:45:12 Re: A newbie's opinion - postgres NEEDS a Windows binary!