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