Re: [SQL] possible bug?

> On Mon, Oct 25, 1999 at 01:22:06AM +0000, Clayton Cottingham allegedly wrote:
> > 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
> > 
> > ive tested in 6.5 and 6.5.2
> 
> This is correct. I've had this problem myself. When you check the source,
> there is a comment about this, but nothing useful. I myself would
> consider this a bug too, but I'm not sure about the developers.
> 

Man pages says:
      The table is actually copied to a temporary table in index      order, then renamed back to the original  name.
For this      reason,  all  grant permissions and other indexes are lost      when clustering is performed.
 



--  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