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 1ibzYd-0004Rw-9q for pgsql-committers@arkaria.postgresql.org; Tue, 03 Dec 2019 04:13:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ibzYb-0004SZ-AG for pgsql-committers@arkaria.postgresql.org; Tue, 03 Dec 2019 04:13:01 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ibzYa-0004Ps-SW for pgsql-committers@lists.postgresql.org; Tue, 03 Dec 2019 04:13:01 +0000 Received: from wout1-smtp.messagingengine.com ([64.147.123.24]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ibzYU-0001KV-1i for pgsql-committers@lists.postgresql.org; Tue, 03 Dec 2019 04:12:59 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.west.internal (Postfix) with ESMTP id 84CF0C28; Mon, 2 Dec 2019 23:12:52 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute4.internal (MEProxy); Mon, 02 Dec 2019 23:12:52 -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=oj64NkRqygjImnTT4y0OJqjHh8P hLCRW5h2+jRjbxoU=; b=NsadD7PaeBXDz0XW0NzQOnh5kEMPyc90TwDmK5QHnDd IOglf4PJ0hata558E6VcPLS4Qby0czslpK4/9VCqKLBuZuDOu0rYCGW3eaZb4RZx 6jKTGxvzk364U2lN/4ZKxrQvBfDHKB1+4duhdZXUJrA9FJhnakKaapzPpxhBHiia HHEVR3U3N/afdS5OIvn81kRyLvu62Bg/rVihIwkby+g7qGbqxTWnxqZrevzTn5bl ChgSxMST6KV4zu5LVVOWliNZFfKse6sGdQmoP08MRZwi5Oizb01Fhy2zZucd1FJa WMDfzV4Mv/jMi0SKqviPsvWwBB7uzvR7yFfPCCOx+Sg== 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=oj64Nk RqygjImnTT4y0OJqjHh8PhLCRW5h2+jRjbxoU=; b=cVFrX/YneM7YwFzCTCEZiP 0HD/TpuwiAb6Ot7TlFws37nx7dBlFlKEsilV5DB2PfFMz/62HHEC2aHiaUlt1ar6 9N1OBkI2gWbA/53Hk68fj/b59M+NnMkxiW1ywTSJ6jbYcIc1B71JcOoB4CSs8c/u ILhf1dakfspIhkU3ZP9JsbFuDTNaSR6/CTBhErjk71U8F4tbxmZ2yIl2UkAsgYjH iRbqCb4liPrzVb17+kewnqgNlqE2j2i7u88rTxEXedpZiiQ9xlQstr1VuVrBlXcX nOlryIf5rCZvIEqJ6cJbEoyd57U/8nwiRVDM7AblHPOjVo1ineN6694UeFo0u94A == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedufedrudejiedgieeiucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne gfrhhlucfvnfffucdljedtmdenucfjughrpeffhffvuffkfhggtggujgesghdtreertddt vdenucfhrhhomhepofhitghhrggvlhcurfgrqhhuihgvrhcuoehmihgthhgrvghlsehprg hquhhivghrrdighiiiqeenucfkphepudduuddruddtvddrudektddrudekheenucfrrghr rghmpehmrghilhhfrhhomhepmhhitghhrggvlhesphgrqhhuihgvrhdrgiihiienucevlh hushhtvghrufhiiigvpedt 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 4D13F80059; Mon, 2 Dec 2019 23:12:50 -0500 (EST) Date: Tue, 3 Dec 2019 13:12:47 +0900 From: Michael Paquier To: Tom Lane Cc: Peter Eisentraut , pgsql-committers@lists.postgresql.org Subject: Re: pgsql: Add a regression test for allow_system_table_mods Message-ID: <20191203041247.GD1634@paquier.xyz> References: <13656.1575041267@sss.pgh.pa.us> <315cfd3b-9d04-0ea4-76d8-1507c8bd9bb7@2ndquadrant.com> <15399.1575043746@sss.pgh.pa.us> <1e7bb9a1-1104-907d-da62-857408d271ef@2ndquadrant.com> <29779.1575299500@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="mJm6k4Vb/yFcL9ZU" Content-Disposition: inline In-Reply-To: <29779.1575299500@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --mJm6k4Vb/yFcL9ZU Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Mon, Dec 02, 2019 at 10:11:40AM -0500, Tom Lane wrote: > One way would be to provide a variant expected-file, but that's not going > to be fun for future maintenance of the test script. Another simple > answer is to crank up client_min_messages for this one test to hide the > WARNING, but you could conjure scenarios where that misses something > important. (Of course, not running the test at all would also miss > any such issue.) Alternate output files should be IMO avoided if we can, so if I were to choose sneaking a SET client_min_messages would be fine, but only for the second create tablespace.. -- Michael --mJm6k4Vb/yFcL9ZU Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAl3l4L8ACgkQnvQgOdby QH2BxBAAjlA8KoP4ZhSdTTfYCybz5RPeTKA8A5LBj7uz8kSKOHp61H1nHJmFcX7L Hlkc/J2SeBpoo5OIKuxFw/ghZ9RcueI+cG3jpgT7St/0heEZunxm1A17PyRKvpkz aKOLkhrhI5NWuU4bZMtZxx60nbaflGCa4e2W8ojiLiFXd+yd1miYn+ciqHYDwzRX oyJQnC7zobZc4hNcwaBdG18WMOhZ5DE1xJmzyqrgEe9+IP0zZiGH5GofyIkRObuK It2hO4tNWdemvFLShvtVLdrkRdvE/EOxW/c1hD4FUOObFAjZrhb3S5xeN+xHM8oU gxjkLXEW+H3Gy2SkP7HCeIKHiyH5lIP9Tqimm4Q3iPSmMkj3kICKRPMgsYGThfsy 8HqxN1wFFOQLxEsWElQAxNr1Rk43d5eLc6LnhDIHsneaqX6WMyaORfdlz2XwZWki RaSsW8M/xRTUU2Z4Td2685k6LAwKgzaBPqRpU65JaicOwCsB/nhg7mwjseDpKvyx TTJgOEu0iMAgJMjfLsTXaZSVAfOWPY6Raq22UaRoOGaFPUc/7gBWYxszA3ZFA6RX xXiu1H2k4T/gxbNWSlAsbun259P1z1TfkK0Ha8XOboodZcNkvuP/CVu8XrUqoNQg A9+qFs94WKFnIcqBGpF18TJSukA1uhGIvxuaBcDwJ1QaEj8LY1w= =kUg5 -----END PGP SIGNATURE----- --mJm6k4Vb/yFcL9ZU--