Re: Adding CLUSTERING removed my indexes

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jon Hassen <jhassen(at)azstarnet(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Adding CLUSTERING removed my indexes
Date: 2002-02-22 01:04:51
Message-ID: 12431.1014339891@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Jon Hassen <jhassen(at)azstarnet(dot)com> writes:
> All of my indexes disappeared, and the permissions changed on my tables
> after I ran the CLUSTER command on one of the indexes.

> Is this normal?

The present implementation of the CLUSTER command pretty much sucks (see
the Notes on its reference page). Sooner or later someone will rewrite
it ...

regards, tom lane

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Singer Wang 2002-02-22 12:17:19 Re: Logging Apache web server log information to Postgresql
Previous Message Diane Moore 2002-02-21 22:55:05 How to determine table definitions