Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YfZNw-0003xN-6c for pgsql-hackers@arkaria.postgresql.org; Tue, 07 Apr 2015 19:42:08 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YfZNv-0006BV-LZ for pgsql-hackers@arkaria.postgresql.org; Tue, 07 Apr 2015 19:42:07 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YfZNu-0006BK-GE for pgsql-hackers@postgresql.org; Tue, 07 Apr 2015 19:42:06 +0000 Received: from mout.gmx.net ([212.227.17.21]) by magus.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YfZNq-0003HD-4H for pgsql-hackers@postgresql.org; Tue, 07 Apr 2015 19:42:05 +0000 Received: from auth1-smtp.messagingengine.com ([66.111.4.227]) by mail.gmx.com (mrgmx103) with ESMTPSA (Nemesis) id 0MarAM-1YzzgA3WWY-00KQDo for ; Tue, 07 Apr 2015 21:42:01 +0200 Received: from compute1.internal (compute1.nyi.internal [10.202.2.41]) by mailauth.nyi.internal (Postfix) with ESMTP id 7966720CD4 for ; Tue, 7 Apr 2015 15:41:54 -0400 (EDT) Received: from frontend2 ([10.202.2.161]) by compute1.internal (MEProxy); Tue, 07 Apr 2015 15:41:58 -0400 X-Sasl-enc: DYUYhtPXNF6YKTsvloNrH7fJBUbmDftQ1paj80ITKKjU 1428435718 Received: from [192.168.1.117] (unknown [204.145.120.11]) by mail.messagingengine.com (Postfix) with ESMTPA id 2A225680100; Tue, 7 Apr 2015 15:41:58 -0400 (EDT) Message-ID: <55243305.4050207@gmx.net> Date: Tue, 07 Apr 2015 15:41:57 -0400 From: Peter Eisentraut User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10; rv:31.0) Gecko/20100101 Thunderbird/31.5.0 MIME-Version: 1.0 To: Alvaro Herrera , Simon Riggs CC: David Steele , PostgreSQL-development Subject: Re: Auditing extension for PostgreSQL (Take 2) References: <54E005CC.1060605@pgmasters.net> <5522EDE9.2050101@gmx.net> <20150406210357.GG4369@alvh.no-ip.org> In-Reply-To: <20150406210357.GG4369@alvh.no-ip.org> Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: 7bit X-Provags-ID: V03:K0:ZanWQxnmnvCVBBg9NVeX4PrUH/TOcg6E7Efk7gaw4oF0hC9qrri EqqcpJxcPi3LAXBHJWrIyEe9j1TpogDoPof31jaTbhwprLYB+czyvHjRfWnGMKspzdXzxti 5/bVn/uUamjOb/jMoekrDbwrc4mpW2emFUvPNl+rX9+Yl6nXDbLwblrxHjtLgfgLkVxC5KD tE/eKs7aI+AWQK51TqL6A== X-UI-Out-Filterresults: notjunk:1; X-Pg-Spam-Score: -1.9 (-) 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 4/6/15 5:03 PM, Alvaro Herrera wrote: > Simon Riggs wrote: > >> The present version can trigger an audit trail event for a statement, >> without tracking the object that was being audited. This prevents you >> from searching for "all SQL that touches table X", i.e. we know the >> statements were generated, but not which ones they were. IMHO that >> makes the resulting audit trail unusable for auditing purposes. I >> would like to see that functionality put back before it gets >> committed, if that occurs. > > Is there a consensus that the current version is the one that we should > be reviewing, rather than the one Abhijit submitted? Last I checked, > that wasn't at all clear. Well, this one is the commitfest thread of record. At quick glance, my comments about "how does this map to specific customer requirements" apply to the other submission as well. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers