CLUSTER removing index from table?
От | Andrew McMillan |
---|---|
Тема | CLUSTER removing index from table? |
Дата | |
Msg-id | 39A5C286.B2A52D84@catalyst.net.nz обсуждение исходный текст |
Ответы |
Re: CLUSTER removing index from table?
|
Список | pgsql-hackers |
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
В списке pgsql-hackers по дате отправления: