From: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Mathijs Brands <mathijs(at)ilse(dot)nl> |
Cc: | Clayton Cottingham <drfrog(at)smartt(dot)com>, "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgreSQL(dot)org> |
Subject: | Re: [SQL] possible bug? |
Date: | 1999-10-26 04:55:03 |
Message-ID: | 199910260455.AAA20176@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
> 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(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
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1999-10-26 04:58:31 | Re: [SQL] possible bug? |
Previous Message | Bruce Momjian | 1999-10-26 04:53:34 | Re: [SQL] possible bug? |