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)
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! |