CLUSTER removing index from table?

From: Andrew McMillan <Andrew(at)catalyst(dot)net(dot)nz>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: CLUSTER removing index from table?
Date: 2000-08-25 00:49:10
Message-ID: 39A5C286.B2A52D84@catalyst.net.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2000-08-25 02:15:50 Re: CLUSTER removing index from table?
Previous Message Chris Bitmead 2000-08-24 23:33:15 Re: AW: How Do You Pronounce "PostgreSQL"?