From: | Andrew McMillan <Andrew(at)catalyst(dot)net(dot)nz> |
---|---|
To: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | CLUSTER removing index from table? |
Date: | 2000-08-25 00:49:10 |
Message-ID: | 39A5C286.B2A52D84@catalyst.net.nz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Has anyone else seen this sort of behaviour? After my CLUSTER command
my other index has vanished! I know someone mentioned they had done a
lot of work on CLUSTER, so perhaps this has been fixed.
I'm running Debian 7.0.2-4, on i386.
Regards,
Andrew.
newsroom=# \d codetable
Table "codetable"
Attribute | Type | Modifier
-------------+---------+----------
table_id | text | not null
code | text | not null
seq | integer |
description | text |
misc | text |
Indices: codetable_pkey,
xak1_codetable
newsroom=# CLUSTER xak1_codetable ON codetable;
CLUSTER
newsroom=# \d codetable
Table "codetable"
Attribute | Type | Modifier
-------------+---------+----------
table_id | text |
code | text |
seq | integer |
description | text |
misc | text |
Index: xak1_codetable
--
_____________________________________________________________________
Andrew McMillan, e-mail: Andrew(at)cat-it(dot)co(dot)nz
Catalyst IT Ltd, PO Box 10-225, Level 22, 105 The Terrace, Wellington
Me: +64 (21) 635 694, Fax: +64 (4) 499 5596, Office: +64 (4) 499 2267
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2000-08-25 02:15:50 | Re: CLUSTER removing index from table? |
Previous Message | Chris Bitmead | 2000-08-24 23:33:15 | Re: AW: How Do You Pronounce "PostgreSQL"? |