Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uN2pb-00AT86-D5 for pgsql-hackers@arkaria.postgresql.org; Thu, 05 Jun 2025 05:07:59 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uN2pZ-003uch-4I for pgsql-hackers@arkaria.postgresql.org; Thu, 05 Jun 2025 05:07:57 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uN2pY-003ucY-RA for pgsql-hackers@lists.postgresql.org; Thu, 05 Jun 2025 05:07:57 +0000 Received: from fhigh-a8-smtp.messagingengine.com ([103.168.172.159]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1uN2pX-000IVG-2Q for pgsql-hackers@lists.postgresql.org; Thu, 05 Jun 2025 05:07:56 +0000 Received: from phl-compute-08.internal (phl-compute-08.phl.internal [10.202.2.48]) by mailfhigh.phl.internal (Postfix) with ESMTP id 0A23C11401DC; Thu, 5 Jun 2025 01:07:55 -0400 (EDT) Received: from phl-mailfrontend-02 ([10.202.2.163]) by phl-compute-08.internal (MEProxy); Thu, 05 Jun 2025 01:07:55 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:subject :subject:to:to; s=fm1; t=1749100075; x=1749186475; bh=ceTRPZZSgD Fgyeh3ODmW/RZPG2Kx8ncbZ1sq44nGefU=; b=VGrMcWQGd2oI3rfTXOOei2GQRO TxdeHFwMBE4wp+DPIy2SllGgIHrpey2jl5oXcfnoNcVm1BWF/vf3tNwWfAFoGJp0 4tlUGgWKA8wTYQBgC5B5Tu1sf/eqlI1oBcTalWbABbvOaR1+fn4J1uOe+KyQoFqj lnO8S9LIgdeaXak0BeWy2xvjZdEdFv8mw+LvLbFbgMCOln5UtwsQykUvP36br8zK v/wYop2L76JqwfDIqSS0JxAxlCtIrkbDbD7CnX7JOl2u9GYWE8Hkwe4Mq+d5UsIq QN4wXgW0+rDZagaArXe8dJ0x7NyMXRdr9nWt3alklASnjnw4dVUXXf3BJKXg== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:subject:subject:to :to:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm1; t= 1749100075; x=1749186475; bh=ceTRPZZSgDFgyeh3ODmW/RZPG2Kx8ncbZ1s q44nGefU=; b=OX5JDu3I7KZxtZJIWptpcIXj9Kt/5buOpaSMxqp7e9yMb0lQYTz gg3xRNCjAbd/YQX7KHh5mJRDqk/mBGVQTfXJnI9uyiiX16JUXHkp0vIe1qS5SAGR Oarl7WdALGNYhIQIcYNI7RxddJg8puszXlZEoxfW2ZLCMrf1KaVBBieD8gq2sOMw e1jXqd9Un3BhzOWf1kQzBOoRKVMwNdW3hhMtINL5QsDSCu//njFkT4n68etaKdK4 Xyk964kkrp/Bc8NcSQiqnZanSmcAHlawUP/6aevpWgzrzpaJFXZyekwHqupeSns1 1sBwTQFb4MpWmfD0MXqeX+2nuwiM9R+pnUA== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeffedrtddugdefudejucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdggtfgfnhhsuhgsshgtrhhisggvpdfu rfetoffkrfgpnffqhgenuceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnh htshculddquddttddmnegfrhhlucfvnfffucdlfeehmdenucfjughrpeffhffvvefukfhf gggtuggjsehgtdorredttddvnecuhfhrohhmpefoihgthhgrvghlucfrrghquhhivghruc eomhhitghhrggvlhesphgrqhhuihgvrhdrgiihiieqnecuggftrfgrthhtvghrnhepueff tdffgefhfeeiudethfehgfffffehlefhudetffefjeetffeiueejfeegtddvnecuffhomh grihhnpehgohhoghhlvgdrtghomhenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgr mhepmhgrihhlfhhrohhmpehmihgthhgrvghlsehprghquhhivghrrdighiiipdhnsggprh gtphhtthhopeehpdhmohguvgepshhmthhpohhuthdprhgtphhtthhopehnohgrhheslhgv rggusghorghtrdgtohhmpdhrtghpthhtoheplhgruhhrvghniidrrghlsggvsegthigsvg hrthgvtgdrrghtpdhrtghpthhtohepthhglhesshhsshdrphhghhdrphgrrdhushdprhgt phhtthhopehprghvvghlrdhsthgvhhhulhgvsehgmhgrihhlrdgtohhmpdhrtghpthhtoh epphhgshhqlhdqhhgrtghkvghrsheslhhishhtshdrphhoshhtghhrvghsqhhlrdhorhhg X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Thu, 5 Jun 2025 01:07:51 -0400 (EDT) Date: Thu, 5 Jun 2025 14:07:44 +0900 From: Michael Paquier To: Noah Misch Cc: Laurenz Albe , Tom Lane , Pavel Stehule , pgsql-hackers@lists.postgresql.org Subject: Re: Wrong security context for deferred triggers? Message-ID: References: <6bca669972ef0d4a665fa83c5b751ab116324f8f.camel@cybertec.at> <2653121.1730737337@sss.pgh.pa.us> <51386e72c47d922ef68eaa67451a52dc3f569843.camel@cybertec.at> <3944969.1737570355@sss.pgh.pa.us> <3e4c8fe7adce2e3956e01bae8f1754830bd2d2bf.camel@cybertec.at> <201480.1737653448@sss.pgh.pa.us> <67338f5d321ae6a4bae646e04b9fe0a1f27dd27c.camel@cybertec.at> <20250415155850.9b.nmisch@google.com> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="c0rY14z6+wcOUT03" Content-Disposition: inline In-Reply-To: <20250415155850.9b.nmisch@google.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --c0rY14z6+wcOUT03 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Tue, Apr 15, 2025 at 08:58:50AM -0700, Noah Misch wrote: > commit 01463e1 wrote: >> +NOTICE: I am regress_groot Ahah. Excellent. > Let's not incur trivially-avoidable trademark risks > (https://google.com/search?q=%22i+am+groot%22) in the source tree. But you may be right that it could be a problem, and that's just a matter of applying a s/regress_groot/regress_dt_user/ or something equivalent, so let's do the change. -- Michael --c0rY14z6+wcOUT03 Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmhBJiAACgkQnvQgOdby QH0Qjw//UCe7meco2RgD8JoqgawMTY4fSmGH8d8m6Z6UAd4bPYTQM/Y2+lJJze+N +m0rc6n5seugUJqt11EQGNpk+/juZoKPEGnxfZKJD+BO63tl5ufGfRE2Pg7fENbj 7i4xjoRmlm1XSzFpZuTIom4g9lNX082o5wY+P49mxNe3O9B9rzGetqdwvfHDyPG9 xp003yuBbkW/LKc8jkerDzz8Yvn6RhYVFZTQjH/GKisIBy/1O/M2TVINs869dvU7 /H7ScZyOj6ezqFsF5kwEdM9YdKcZ3rNqTxstuNt+bUIO2yN35hLtG5EpjRF9Hip1 5QRdwonfwMEH/kSmN9vlazKc50byqcAKCtHkWX+2x49aVgiQIg2Eu/yRhZiFYfCJ /RxbFMffMeGodTBIo3140aukvauqhmfdt1E3R1mZ76xxD6Jsx3jlvHspLEjZWl9D mFdzS8q9kBisvGANRInqoFLkrefEylhWSPcw1+QHOhZcY19NqG8qzFtouJoCDU2S la2lT4MwsuJ5s/hJQO1MGT3nCuXah2aBS9PA2Ksbuq9EtAuewGjeqxMWpjVDtLJm kierWUZ5K9q2H9YL7voGDGf79jS95fNcur+VPG/+L8fBTUuFDRUURVD4c2P1NKLt lOXiBURevuj+5892ZV/gvmqlevXkprp7wcz7eo8SWpaTOyBgqvU= =PUW3 -----END PGP SIGNATURE----- --c0rY14z6+wcOUT03--