Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1aB6nc-0007vU-9U for pgsql-hackers@arkaria.postgresql.org; Mon, 21 Dec 2015 20:11:16 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1aB6nb-0000iT-S3 for pgsql-hackers@arkaria.postgresql.org; Mon, 21 Dec 2015 20:11:15 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1aB6mI-0007YP-0W for pgsql-hackers@postgresql.org; Mon, 21 Dec 2015 20:09:54 +0000 Received: from bay.acenet.us ([173.230.252.50]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1aB6mF-0007Ve-UD for pgsql-hackers@postgresql.org; Mon, 21 Dec 2015 20:09:52 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=anastigmatix.net; s=default; h=Content-Transfer-Encoding:Content-Type: In-Reply-To:MIME-Version:Date:Message-ID:From:Cc:References:To:Subject; bh=k+6WVkU+3NYgtvqsWuU2zHr9pygs3hbY/4tDwYsWDfo=; b=QInc8VBIda1lL55MvvAAGAJC6S VLqXbB7I4CKbrbld22ryu/vfI0uDD0OATYrFzcm+dZf8PIDPssp9f08e+lYyJek3egexiV+WWy87l OzA7+obW6siyzqUahWHxrqxwBPCRiegywW1ADjQdw+W1WOiLOX2eqSQfR6A3RslQvwSRUqi08bn3c eJf9MAi3K9GFxQ0mm9F8lxJYJZ7M/mDW54V+WIenRzP3i3MV+AbrqABHnOfmG+VrLWxLaT5kr8aDs MR+QeFUYC4nbarEJInr+p58kVs2cdiblD2ttZDPMz88P6kKXGskmOP7nDI4F9zF7899YRGcd9cNap uS+aUzwg==; Received: from pythagoras.math.purdue.edu ([128.210.3.44]:41408) by bay.acenet.us with esmtpsa (TLSv1.2:AES128-SHA:128) (Exim 4.86) (envelope-from ) id 1aB6mD-000AC1-L2; Mon, 21 Dec 2015 15:09:50 -0500 Subject: Re: tracking owner of extension-managed objects To: Tom Lane References: <56783412.6090005@anastigmatix.net> <3486.1450720004@sss.pgh.pa.us> <56785344.6080803@anastigmatix.net> Cc: PostgreSQL Hackers From: Chapman Flack Message-ID: <56785C8C.6060006@anastigmatix.net> Date: Mon, 21 Dec 2015 15:09:48 -0500 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:38.0) Gecko/20100101 Thunderbird/38.4.0 MIME-Version: 1.0 In-Reply-To: <56785344.6080803@anastigmatix.net> Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: 7bit X-OutGoing-Spam-Status: No, score=-0.2 X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - bay.acenet.us X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - anastigmatix.net X-Get-Message-Sender-Via: bay.acenet.us: authenticated_id: chap+anastigmatix.net/only user confirmed/virtual account not confirmed X-Authenticated-Sender: bay.acenet.us: chap@anastigmatix.net X-Source: X-Source-Args: X-Source-Dir: X-Pg-Spam-Score: -1.8 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org On 12/21/2015 02:30 PM, Chapman Flack wrote: > On 12/21/2015 12:46 PM, Tom Lane wrote: >> all, since we don't provide a way for extensions to hook into the DROP >> mechanisms. Perhaps that should be fixed.) > > That is literally *the very next* e-mail I was going to compose. > > I was looking at pg_(sh)?depend, ... > I can probably cobble around this with some > combination of triggers on my own table ('cause that works) and > event triggers to grovel through the parse trees of commands that > could affect the system object, right, I can't event-trigger on role commands either, can I? What's the lightest-weight object I can create that has an owner, and whose disappearance I can be notified of? -Chap -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers