Re: [SQL] possible bug?

> Clayton Cottingham <drfrog(at)smartt(dot)com> writes:
> > can anyone confirm this?
> > create index idx on table using btree(column );
> > cluster idx on table;
> > drop index idx;
> > seems to drop all permissions and indexes
> > on the table involved
>
> "cluster" deliberately drops all other indexes on the target table,
> according to the source code. (If this isn't mentioned in the
> documentation, it should be.)
>
> It looks like the implementation method is to build a whole new
> table, destroy the old, and rename the new into place. That probably
> explains why the permissions get lost --- I suppose triggers &etc
> are not carried over either, and heaven help you if you try to cluster
> a member of an inheritance hierarchy...
>
> I have no idea how hard it'd be to make a less destructive version
> of "cluster". Another item for the TODO list, I guess.
>

Already on TODO list. Text added to make it clearer.

--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026