CLUSTER removing index from table?
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@cat-it.co.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
Known problem with CLUSTER. See CLUSTER manual page.
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_codetablenewsroom=# 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@cat-it.co.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
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026