X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A937153A8E for ; Sat, 14 May 2005 02:30:57 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 98237-05 for ; Sat, 14 May 2005 05:30:55 +0000 (GMT) Received: from mr2.surnet.cl (smtp2.surnet.cl [216.155.73.163]) by svr1.postgresql.org (Postfix) with ESMTP id 9474F53884 for ; Sat, 14 May 2005 02:30:53 -0300 (ADT) Received: from smtp2.surnet.cl (216.155.73.169) by mr2.surnet.cl (7.0.031.3) id 4259ADFA0073F437; Sat, 14 May 2005 01:31:27 -0400 Received: from smtp2.surnet.cl (mr2.surnet.cl []) by mr2.surnet.cl ([216.155.73.169]); Sat, 14 May 2005 05:31:27 +0000 Received: from cluster.surnet.cl (216.155.73.164) by smtp2.surnet.cl (7.0.031.3) id 4259ADE300471403; Sat, 14 May 2005 01:31:27 -0400 Received: from localhost (200.85.220.212) by cluster.surnet.cl (7.0.024) id 4276578F001B2FD4; Sat, 14 May 2005 01:30:50 -0400 Received: by localhost (Postfix, from userid 1000) id 2E599C32DDE; Sat, 14 May 2005 01:30:53 -0400 (CLT) Date: Sat, 14 May 2005 01:30:53 -0400 From: Alvaro Herrera To: Tom Lane Cc: "Harris, Richard" , pgsql-admin@postgresql.org Subject: Re: Permissions not removed when group dropped Message-ID: <20050514053053.GA26186@surnet.cl> References: <20050513213505.GB17830@surnet.cl> <172.1116038893@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <172.1116038893@sss.pgh.pa.us> User-Agent: Mutt/1.5.9i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=2.23 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, FORGED_RCVD_HELO, RCVD_IN_NJABL_PROXY X-Spam-Level: ** X-Archive-Number: 200505/198 X-Sequence-Number: 17627 On Fri, May 13, 2005 at 10:48:13PM -0400, Tom Lane wrote: > Alvaro Herrera writes: > > We are working on it, and hopefully in 8.1 you will be told where the > > user/group is referenced if you try to drop it. Automatically deleting > > the references from all ACLs has not been discussed but it's a possible > > outcome of the implementation. > > [ raised eyebrow... ] You expect to be able to tell anything about the > internals of a different database? Much less do anything to it? No, that's why I haven't mentioned it :-) I know I can't do anything about objects in other databases. But I have wondered if we could implement CASCADE behavior for an object whose dependencies are only local to the current database (where CASCADE actually mean delete references in ACLs, and reject the action altogether if there is an ownership reference. And of course, if the object is a tablespace, reject as well.) -- Alvaro Herrera () "La persona que no quería pecar / estaba obligada a sentarse en duras y empinadas sillas / desprovistas, por cierto de blandos atenuantes" (Patricio Vogel)