Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1n64BY-0005ng-CU for pgsql-committers@arkaria.postgresql.org; Sat, 08 Jan 2022 05:22:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1n64BX-0000rG-7S for pgsql-committers@arkaria.postgresql.org; Sat, 08 Jan 2022 05:22:35 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1n64BX-0000r7-0D for pgsql-committers@lists.postgresql.org; Sat, 08 Jan 2022 05:22:35 +0000 Received: from wout1-smtp.messagingengine.com ([64.147.123.24]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1n64BT-0000VX-Mk for pgsql-committers@lists.postgresql.org; Sat, 08 Jan 2022 05:22:34 +0000 Received: from compute6.internal (compute6.nyi.internal [10.202.2.46]) by mailout.west.internal (Postfix) with ESMTP id 3BC99320100E; Sat, 8 Jan 2022 00:22:27 -0500 (EST) Received: from mailfrontend2 ([10.202.2.163]) by compute6.internal (MEProxy); Sat, 08 Jan 2022 00:22:27 -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=pogKqz/Y8+bXOsuTrX/JT+9nsi6 kgsoTtnjg3P2tQiA=; b=VWq7N2nfY/V/01F2QIie+zpNANl68i0a7KYx4cARomJ ftYu4GmiCWP/bvincSuLVBnDhhdCd+5m9TtpKe6fAcic99aylDVJ4tDR44ceeZ/J shtKoBqbl5QNbijBLZR9D7Jmk42HQMaNOz6VeGRMSstZyxPCeiHK6o5AIaUNYeVz NFHZN/Mf1HYiM3wrEtXS+YQXIoaQj42PsMBqFKPY55vrt9n2XFvBVq0BSGSrP39x 4UjLxWxXKYRZW+c1ca+cmYcbGdaNDoYD/3JVs46bvUP1qVyAXPDV8R4JR1dK4GR0 JuPgmevsYKphd1dUiHpf7xOJlTQ7cHR6n4dQv+QtclA== 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=pogKqz /Y8+bXOsuTrX/JT+9nsi6kgsoTtnjg3P2tQiA=; b=O2WAiUEZ/1gKYtNX6B6/aD 3TZuO/P4lzxjRv8KCiYDiyGFSPcSIDDc8h+i4KCoAs47vaHRk/60xsFwtniQCIp5 ypHarpO+Yhua2YoLqvZ0odQLaxhe6Fklcan5ILbMRPL/BXCcsWcUqZXlxXRr9o06 qtgZeliBpJmjjbvOpmMfEEY32zqAjnydi/f68O9h024IwCpuEVmjPtR8wI+cmGqT K3wz+YLMSgdzHfl9TffsrsFaNEJvK1T4IcnqbA/0WgWCYSiiL2/YzH7oebGPiUnD ymc5ZUD6PXR28yiXsbxJi1/gC34147HnCspU/67hTwUBBi1AI4+lg+dNn56icH/g == X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvuddrudegfedgkedvucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne gfrhhlucfvnfffucdlfeehmdenucfjughrpeffhffvuffkfhggtggujgesghdtreertddt vdenucfhrhhomhepofhitghhrggvlhcurfgrqhhuihgvrhcuoehmihgthhgrvghlsehprg hquhhivghrrdighiiiqeenucggtffrrghtthgvrhhnpeffudeffeelgffhkedukeekvedv udfgieetkeekudelfeevhffhffdtudffieeutdenucffohhmrghinhepphhoshhtghhrvg hsqhhlrdhorhhgnecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhf rhhomhepmhhitghhrggvlhesphgrqhhuihgvrhdrgiihii X-ME-Proxy: Received: by mail.messagingengine.com (Postfix) with ESMTPA; Sat, 8 Jan 2022 00:22:25 -0500 (EST) Date: Sat, 8 Jan 2022 14:22:23 +0900 From: Michael Paquier To: Jeff Davis Cc: pgsql-committers@lists.postgresql.org Subject: Re: pgsql: Respect permissions within logical replication. Message-ID: References: MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="w9DJ5gx4a4sdYbEI" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --w9DJ5gx4a4sdYbEI Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Hi Jeff, On Sat, Jan 08, 2022 at 02:40:56AM +0000, Jeff Davis wrote: > Respect permissions within logical replication. The buildfarm is not completely happy after this commit: 1) massasauga is failing the new test: https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=massasauga&dt=2022-01-08%2002%3A45%3A21 # Failed test 'superuser admin replicates insert into unpartitioned' # at t/027_nosuperuser.pl line 46. # got: '2|1|3' # expected: '3|1|5' # Looks like you failed 1 test of 100. 2) crake fails perl-check https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=crake&dt=2022-01-08%2002%3A47%3A26 All the failures are the same, because of the shape of the subroutine definitions: Jan 07 21:53:04 ./src/test/subscription/t/027_nosuperuser.pl: Subroutine prototypes used at line 13, column 1. See page 194 of PBP. ([Subroutines::ProhibitSubroutinePrototypes] Severity: 5) Thanks, -- Michael --w9DJ5gx4a4sdYbEI Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmHZH48ACgkQnvQgOdby QH1ZvRAAkrO0WvVbXIWkcEU+RGA0/OSKt3aLDRsbNX2X8JspdI5nyn3a2Vt5Smi/ 5nL1avGwoJgY3iaY0PyzGLjKc5eoz8z8U6cybwGb8mm+HrAPK7SZExp6Nl7rmqqF JJMv2nWkASusHTgi3aER7si7rxkap/LF9fmfEfBb4TlGCR96sLRoUU+XL9QYbGZ/ sn5aJum4wK/GrDh2Sb25SnHHf0n6RUcvzt16fq8W4fsBh1BHnlLSCjSa4HZ9YJul Ah3i98HBk7iNJv28bn3aJawctWBHMMLUSIVK7DR279r6yy+bt4Z/GFLhw4fDwU+7 Sv6EdjjEloAN5pJ7KDddyF92xg9KjJAcmKzAmqlRr4apwBfdluJymCzySQvmCPFe 2wKQPunReSjgyQGsHvRG0EEMB4QZf49eGUO2Ss0QrgvK1hQxZ9Eb+L+TH4NeePfk YO7mHI18z+uBCzv+1cdymO/63R/Mj2a7rm4e1vGB3LhwJexatrrsIXy38jKhwPNG WS6mv6olH97Elrx1Nl5UD41oQQPAf3cmNN3xavYz8tC42o3JZ/dlk4E4YZ885qBt Vq39gT3tLVIVUBYDeoFkaOZVr0F/x3XbxBrEsAJ1Qz00a2NwDNtGBh8ZLBliY/Nl lEUnXDCBdPwkUqY2NxSWSSG7wZCgz/sz2TM8IbKufqYQq/Wzu20= =aomu -----END PGP SIGNATURE----- --w9DJ5gx4a4sdYbEI--