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 nullcode | text | not nullseq | 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