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?  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Chris Bitmead
Дата:
Сообщение: Re: AW: How Do You Pronounce "PostgreSQL"?
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: CLUSTER removing index from table?