Received: from sss.pgh.pa.us (sss.pgh.pa.us [209.114.132.154]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eAT7AWt17162 for ; Wed, 29 Nov 2000 02:10:33 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.1/8.11.1) with ESMTP id eAT7ARw26811; Wed, 29 Nov 2000 02:10:27 -0500 (EST) To: Jens Hartwig cc: pgsql-sql@postgresql.org Subject: Re: Damaged table "pg_access" In-reply-to: <3A249FBD.F99C5C0C@debis.com> References: <3A2366CE.5FB828E@debis.com> <14900.975423998@sss.pgh.pa.us> <3A249FBD.F99C5C0C@debis.com> Comments: In-reply-to Jens Hartwig message dated "Wed, 29 Nov 2000 07:18:37 +0100" Date: Wed, 29 Nov 2000 02:10:27 -0500 Message-ID: <26808.975481827@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200011/272 X-Sequence-Number: 303 Jens Hartwig writes: > My next question is: how can I (as a > workaround till version 7.1) permanently remove a group without facing > this problem? Can I rudely remove the granted permissions by any command > (e.g. deleting it manually from the system catalogue)? There isn't any code to scan through the table ACLs and remove references to a particular group or user (if there were, DROP GROUP would be invoking it already). Feel free to submit some... regards, tom lane