CLUSTER removing index from table?

Started by Andrew McMillanover 25 years ago2 messageshackers
Jump to latest
#1Andrew McMillan
andrew@catalyst.net.nz

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

#2Bruce Momjian
bruce@momjian.us
In reply to: Andrew McMillan (#1)
Re: CLUSTER removing index from table?

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_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

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