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 <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1tb12f-007EMG-NU
	for pgsql-hackers@arkaria.postgresql.org; Thu, 23 Jan 2025 17:30:58 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1tb12e-001CXd-P0
	for pgsql-hackers@arkaria.postgresql.org; Thu, 23 Jan 2025 17:30:56 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <tgl@sss.pgh.pa.us>)
	id 1tb12e-001CXV-G1
	for pgsql-hackers@lists.postgresql.org; Thu, 23 Jan 2025 17:30:56 +0000
Received: from sss.pgh.pa.us ([68.162.161.243])
	by magus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <tgl@sss.pgh.pa.us>)
	id 1tb12b-0017f5-2W
	for pgsql-hackers@lists.postgresql.org;
	Thu, 23 Jan 2025 17:30:56 +0000
Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1])
	by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 50NHUmCP201481;
	Thu, 23 Jan 2025 12:30:49 -0500
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Laurenz Albe <laurenz.albe@cybertec.at>
cc: Pavel Stehule <pavel.stehule@gmail.com>,
        pgsql-hackers@lists.postgresql.org
Subject: Re: Wrong security context for deferred triggers?
In-reply-to: <3e4c8fe7adce2e3956e01bae8f1754830bd2d2bf.camel@cybertec.at>
References: <77ee784cf248e842f74588418f55c2931e47bd78.camel@cybertec.at>
 <dede297a-3d24-7029-dfd9-06aeef8b9766@enterprisedb.com>
 <6f27f51bc98354d7254bbde1c171fa13aca03f28.camel@cybertec.at>
 <77b89e609f21380785865542609fbc14010021c8.camel@cybertec.at>
 <CAFj8pRDcE3+9EM+PSSEW1bHA-EWMAYgVog41q0c47N=Pnq_qiQ@mail.gmail.com>
 <3f0a08f3e3d445137ae287125bc8c1a007045db8.camel@cybertec.at>
 <CAFj8pRCCdL_vB-42161CWxemBVqF75WOq53cMnmRCrzjvKpLOQ@mail.gmail.com>
 <66021ca9d81c4e1a22b6c417659b05424e130f27.camel@cybertec.at>
 <CAFj8pRB1UVUuEh_T7j7XFo8yYDuEYxoUgMhPXbny6dK1eCvgRg@mail.gmail.com>
 <6bca669972ef0d4a665fa83c5b751ab116324f8f.camel@cybertec.at>
 <CAFj8pRDcy2OaPS7OtceFRhTRq6VKWbdnuawgaX3EXMQVwTR4VA@mail.gmail.com>
 <2653121.1730737337@sss.pgh.pa.us>
 <51386e72c47d922ef68eaa67451a52dc3f569843.camel@cybertec.at>
 <3944969.1737570355@sss.pgh.pa.us>
 <3e4c8fe7adce2e3956e01bae8f1754830bd2d2bf.camel@cybertec.at>
Comments: In-reply-to Laurenz Albe <laurenz.albe@cybertec.at>
	message dated "Thu, 23 Jan 2025 11:26:57 +0100"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <201479.1737653448.1@sss.pgh.pa.us>
Date: Thu, 23 Jan 2025 12:30:48 -0500
Message-ID: <201480.1737653448@sss.pgh.pa.us>
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Archived-At: 
 <https://www.postgresql.org/message-id/201480.1737653448%40sss.pgh.pa.us>
Precedence: bulk

Laurenz Albe <laurenz.albe@cybertec.at> writes:
> Version 5 of the patch is attached.

Pushed with some cosmetic adjustments, such as tweaking comments.
One perhaps less than cosmetic adjustment is that I removed the
test case involving dropping the role.  I didn't think it was
buying much now that we removed the code that was trying to do
something special in that situation.  (Perhaps there is an argument
for having some testing of the system's behavior when running as a
dropped role, but I doubt that this is the place to start on that.)

			regards, tom lane