Re: [SQL] possible bug?

> Clayton Cottingham <drfrog@smartt.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@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026