Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iZ9N6-0008Tv-RK for pgsql-hackers@arkaria.postgresql.org; Mon, 25 Nov 2019 08:05:24 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iZ9N5-0005LF-KE for pgsql-hackers@arkaria.postgresql.org; Mon, 25 Nov 2019 08:05:23 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iZ9N5-0005L8-BK for pgsql-hackers@lists.postgresql.org; Mon, 25 Nov 2019 08:05:23 +0000 Received: from wout4-smtp.messagingengine.com ([64.147.123.20]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iZ9N2-0007bT-Hr for pgsql-hackers@postgresql.org; Mon, 25 Nov 2019 08:05:22 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.west.internal (Postfix) with ESMTP id 59184595; Mon, 25 Nov 2019 03:05:18 -0500 (EST) Received: from mailfrontend2 ([10.202.2.163]) by compute4.internal (MEProxy); Mon, 25 Nov 2019 03:05:18 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= date:from:to:cc:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm3; bh=+ZAGiAR0qA9HzSMG+fBhuSB+hJD fppwc/6tKtD1KbIY=; b=eAL0TtrE28Cy2BafoIagJAQbQdz46iOQCOzFjYCFbpw /BQfRHwmxpZ7qhnyyNX0STaxXwlBtxY9V4oz7oPTh4Y58cHBozS3ATxL/zld8WSS nSCtYFR5H7V55gjr3GI+6wz1Gp9wU419UzuBJ82TLSiLtx31d/OxraylO0XKSTQC UT0vMgcttdkdPSOYEhDJ0B1qABS5oDvzv0dl/6PdIN1JxhF+t747MfrppYP67dey B6yU8MNWlcCBXt7YAUlaKeVysg7izWKf55ayDR2vHaeERAlazlI+enBYHDOgbqSX ut/tZTVqHpUITDutzGoI4jvOUN/Fc/or123Xn7Pp2zw== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm1; bh=+ZAGiA R0qA9HzSMG+fBhuSB+hJDfppwc/6tKtD1KbIY=; b=ACUAdb4iacfhjfhdLw1Z4D hnfH9x5pXPoac0b0dHQRIlZDXbVD8YCIeKEd+rIWRXfPxzfOC8pt5SJF0hPoKqS5 /ebzPf/GBT0Z0SxKTam1zfOiaTf6s58iPpX/b2rllx7NEOynnt9PHs+Ddl++nHpA 3oJvPIpiMmZtecFXwPMhwMIdAs6So/exCUSMklQH1K8ugySuH3flcEN6vGubfW3W ugmD3Nj3GEAlThiVqssIExQ+V4kRDCm9ldwEqyUEJQ7cSsSyffPnuwUxeOleOAeg CUnhTDunUkIfZc+GezApZyirFbD8X/eBzbIyDczQDssA3Kez8vI6xZgeQjOiZYKg == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedufedrudeitddgheegucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne gfrhhlucfvnfffucdljedtmdenucfjughrpeffhffvuffkfhggtggujgesghdtreertddt vdenucfhrhhomhepofhitghhrggvlhcurfgrqhhuihgvrhcuoehmihgthhgrvghlsehprg hquhhivghrrdighiiiqeenucfkphepudduuddruddtvddrudektddrudekheenucfrrghr rghmpehmrghilhhfrhhomhepmhhitghhrggvlhesphgrqhhuihgvrhdrgiihiienucevlh hushhtvghrufhiiigvpedu X-ME-Proxy: Received: from paquier.xyz (ee0822lan1.rev.em-net.ne.jp [111.102.180.185]) by mail.messagingengine.com (Postfix) with ESMTPA id CFB5B306005B; Mon, 25 Nov 2019 03:05:15 -0500 (EST) Date: Mon, 25 Nov 2019 17:05:12 +0900 From: Michael Paquier To: Andres Freund Cc: Alexey Bashtanov , Alvaro Herrera , Peter Eisentraut , PostgreSQL Hackers Subject: Re: log bind parameter values on error Message-ID: <20191125080512.GL99720@paquier.xyz> References: <20190920174627.qmaditduxlrrzb5l@alap3.anarazel.de> <20190920195657.GA20546@alvherre.pgsql> <20190920203905.xkv5udsd5dxfs6tr@alap3.anarazel.de> <4e374af0-5a2b-73fa-3dfe-d180fcd2ee3e@imap.cc> <20191107234104.5vjj2nh3jdx3uvqo@alap3.anarazel.de> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="CgTrtGVSVGoxAIFj" Content-Disposition: inline In-Reply-To: <20191107234104.5vjj2nh3jdx3uvqo@alap3.anarazel.de> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --CgTrtGVSVGoxAIFj Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Thu, Nov 07, 2019 at 03:41:04PM -0800, Andres Freund wrote: > The way you do it you need to do it in numerous places, and I'm pretty > sure you're missing some already. E.g. this will not work to log > parameters for parametrized statements generated on the server side, > e.g. for foreign key queries. I don't think that's the right direction > to go. You can maybe argue that we don't need support for logging server > side generated parameters in the initial version, but the approach > should be compatible with adding that support. This patch had a review from two committers, with no updates from the author, so marked as returned with feedback. -- Michael --CgTrtGVSVGoxAIFj Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAl3bizgACgkQnvQgOdby QH0CTRAAgJrOUIi5IWV8gKFvfBCLHgcfX5e55xWKj4aebbVJjavHEdmGA3zHFCQw YrRqLsElD5do13rcX92IE2O/eLGGZpgwuKJvjrU29+IXovigOiAJbLZiY7JJtcw3 QO30aFuic04M2IWAks5JWMVLLGPTqYTvR0GNFdvaWS03dli64IUgD7Jv0Uxfl6DH SCjtBYoGa+UAwTRInh15HrjTePYTbOUZC79VJvfpQGWT3bHD3zZ9CkTv3frjS284 b2MUXTw3VNnW7f7naawXwd3O5rDfTev8lrZ/qSlRXdLZ5YhgEbzWkgoOLTRGwO48 /5DZCT5cyXza0z8JkZxyAshzMqcQXUU474a5PTTbT3KuG/owndHLLUHT2fu3SUVw ol0LzUsHhsS7qJ7j/oRWJpgZ8f/go+EXmmr242sLvlC8FmwQtFGuURlRxv/i35Rv 5EMofMP95LwvVa5v+ncQ3aMcqRwCfZlVLRFOKkc3Pmkk1sJ7FrFmGHtLLM9CmHL/ A8+3S0jPWr+dnWIYnR6YFANfr4SS390h9TvNjLZWpTXdazv9GYi3+GkiDdPNYG8X dIKDlbTSCsXfOfRHk3B/qljeHcUBTFXHNSgKFa8IpAokoAmMBRtj3KC8jtfIrCK2 HBhTdY+zFpEXIfr75V08yFZ1VmXLfsShcsq/pgSxu9wkJd2yuLM= =BTjn -----END PGP SIGNATURE----- --CgTrtGVSVGoxAIFj--