Received: from Radha.DoCS.UU.SE (root@Radha.DoCS.UU.SE [130.238.9.99]) by hub.org (8.9.3/8.9.3) with SMTP id EAA99904 for ; Mon, 25 Oct 1999 04:52:40 -0400 (EDT) (envelope-from e99re41@DoCS.UU.SE) Received: from Krabba.DoCS.UU.SE (e99re41@Krabba.DoCS.UU.SE [130.238.9.177]) by Radha.DoCS.UU.SE (8.6.12/8.6.12) with ESMTP id KAA15002; Mon, 25 Oct 1999 10:52:36 +0200 Received: from localhost (e99re41@localhost) by Krabba.DoCS.UU.SE (8.6.12/8.6.12) with SMTP id KAA08363; Mon, 25 Oct 1999 10:52:35 +0200 X-Authentication-Warning: Krabba.DoCS.UU.SE: e99re41 owned process doing -bs Date: Mon, 25 Oct 1999 10:52:34 +0200 (MET DST) From: Peter Eisentraut Reply-To: Peter Eisentraut To: Clayton Cottingham cc: "pgsql-sql@postgresql.org" Subject: Re: [SQL] possible bug? In-Reply-To: <3813B0BD.7A65BCEF@smartt.com> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII From the manual for CLUSTER: "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." So this is not a bug in the sense that no one knows about it, but it's an unfortunate side-effect for sure. -Peter On Mon, 25 Oct 1999, Clayton Cottingham 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 > > > > ************ > > -- Peter Eisentraut Sernanders vaeg 10:115 peter_e@gmx.net 75262 Uppsala http://yi.org/peter-e/ Sweden