Received: from serv0.ilse.net (serv0.ilse.nl [194.158.182.236]) by hub.org (8.9.3/8.9.3) with ESMTP id WAA52219 for ; Sun, 24 Oct 1999 22:49:03 -0400 (EDT) (envelope-from mathijs@ilse.nl) Received: (from mathijs@localhost) by serv0.ilse.net (8.8.8/8.6.12) id EAA15915; Mon, 25 Oct 1999 04:48:58 +0200 (MET DST) Date: Mon, 25 Oct 1999 04:48:58 +0200 From: Mathijs Brands To: Clayton Cottingham Cc: "pgsql-sql@postgresql.org" Subject: Re: [SQL] possible bug? Message-ID: <19991025044858.A15895@ilse.nl> References: <3813B0BD.7A65BCEF@smartt.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 1.0pre4i In-Reply-To: <3813B0BD.7A65BCEF@smartt.com>; from drfrog@smartt.com on Mon, Oct 25, 1999 at 01:22:06AM +0000 X-Unexpected-Header: The Spanish Inquisition 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. Hmm, another useles email. Mathijs