> 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