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

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026