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

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

pgsql-novice by date

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

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