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 1t7zqS-001PaL-Qm
	for pgsql-hackers@arkaria.postgresql.org; Mon, 04 Nov 2024 16:22:24 +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 1t7zqQ-0031C9-86
	for pgsql-hackers@arkaria.postgresql.org; Mon, 04 Nov 2024 16:22:22 +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 <tgl@sss.pgh.pa.us>)
	id 1t7zqP-0031Bt-Us
	for pgsql-hackers@lists.postgresql.org; Mon, 04 Nov 2024 16:22:22 +0000
Received: from sss.pgh.pa.us ([68.162.161.243])
	by makus.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 1t7zqN-0009eE-PK
	for pgsql-hackers@lists.postgresql.org; Mon, 04 Nov 2024 16:22:21 +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 4A4GMHoT2653122;
	Mon, 4 Nov 2024 11:22:17 -0500
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Pavel Stehule <pavel.stehule@gmail.com>
cc: Laurenz Albe <laurenz.albe@cybertec.at>,
        pgsql-hackers@lists.postgresql.org
Subject: Re: Wrong security context for deferred triggers?
In-reply-to: 
 <CAFj8pRDcy2OaPS7OtceFRhTRq6VKWbdnuawgaX3EXMQVwTR4VA@mail.gmail.com>
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>
Comments: In-reply-to Pavel Stehule <pavel.stehule@gmail.com>
	message dated "Sat, 19 Oct 2024 19:13:18 +0200"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <2653120.1730737337.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Mon, 04 Nov 2024 11:22:17 -0500
Message-ID: <2653121.1730737337@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/2653121.1730737337%40sss.pgh.pa.us>
Precedence: bulk

Pavel Stehule <pavel.stehule@gmail.com> writes:
> I'll mark this patch as ready for committer

The cfbot points out a minor problem [1]:

 create role groot;
+WARNING:  roles created by regression test cases should have names starti=
ng with "regress_"
 create role outis;
+WARNING:  roles created by regression test cases should have names starti=
ng with "regress_"
 create function whoami() returns trigger language plpgsql

(You can compile with -DENFORCE_REGRESSION_TEST_NAME_RESTRICTIONS
to enable these warnings locally.)

			regards, tom lane

[1] http://cfbot.cputube.org/highlights/all.html#4888