Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group