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 1nbv4C-0000hq-JU for pgsql-hackers@arkaria.postgresql.org; Wed, 06 Apr 2022 02:06:41 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nbv4B-0006XN-3b for pgsql-hackers@arkaria.postgresql.org; Wed, 06 Apr 2022 02:06:39 +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 1nbv49-0006WW-7q for pgsql-hackers@lists.postgresql.org; Wed, 06 Apr 2022 02:06:38 +0000 Received: from wout4-smtp.messagingengine.com ([64.147.123.20]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nbv40-0008Pw-Tu for pgsql-hackers@lists.postgresql.org; Wed, 06 Apr 2022 02:06:36 +0000 Received: from compute3.internal (compute3.nyi.internal [10.202.2.43]) by mailout.west.internal (Postfix) with ESMTP id A12513200D98; Tue, 5 Apr 2022 22:06:24 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute3.internal (MEProxy); Tue, 05 Apr 2022 22:06:24 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=anarazel.de; h= cc:cc:content-type:date:date:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:sender:subject :subject:to:to; s=fm1; bh=gTMNoHrpNrHsu4PND41OIA/8Xb7s0rGUh/9G4P xfRMg=; b=IHyTqE0TN+WE3gWxH5+wWTvOL1ud0N1jArsoWigkSTgQcbIetOHbR/ E3GmAeYNcQoKOkKEW0xEvPspgfwKswSsisoJzShOOFRWeS+4c+26DBXKgF0I/xA6 Ds6P2holrF/L2lM10lvolqeWDFCphwICd+XERwL4AI/SodLoEA3WFSf+u2QSX3Bp mieVjZie3rFk7iJdzSt7oFNbIQBdOL5sOoogLWRMT4PkiUE88ZgF9snACDdQ4CX0 UOf72dTjcb15fQS1Ocgs4680hpARknNPU0U+jpjNm/g3s+SRvi6it0MOiOfMamRJ ajXTc+S4u7LT2ZmnNH55V0kZ+hpD6+ew== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:date:date:from:from :in-reply-to:in-reply-to:message-id:mime-version:references :reply-to:sender:subject:subject:to:to:x-me-proxy:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm3; bh=gTMNoHrpNrHsu4PND 41OIA/8Xb7s0rGUh/9G4PxfRMg=; b=IKjbEIcU6iEx4xz2D81sHlW8pfqIzfIFX fzrysRth6+2SUCbSUyZOelyCQCRxuDgxkIieWat/NkBudRGCzwUVMiaGBOdBjedb Sig7iM1HWpp4bJ/qvk7yUv8FkQSn3/Jdfz8gTi37Qi0GVHOzH0pL3ZX2UmHiO/08 1Dn69tkwOyuDmEs9fAknQ6LM/5+1eo1+3A6IVX+7ocLLFyK0Jb9aJWLQi3hzGVaL H167RBrGyDYboGjOb7AIHgM7gN8cyeRzowSJM0Dov2idD0vdCk6RolU0JuRomhF+ rgAuXa9QdOyZhv22L1aakwHuK1h+svVBrFK9R2BIp+opMGyNvgn1w== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvvddrudejhedgheefucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepfffhvffukfhfgggtuggjsehttdertddttddvnecuhfhrohhmpeetnhgurhgv shcuhfhrvghunhguuceorghnughrvghssegrnhgrrhgriigvlhdruggvqeenucggtffrrg htthgvrhhnpedukefhkeelueegveetheelffffjeegleeuudelfeefuedtleffueejfffh ueffudenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpe grnhgurhgvshesrghnrghrrgiivghlrdguvg X-ME-Proxy: Received: by mail.messagingengine.com (Postfix) with ESMTPA; Tue, 5 Apr 2022 22:06:23 -0400 (EDT) Date: Tue, 5 Apr 2022 19:06:21 -0700 From: Andres Freund To: Peter Eisentraut Cc: Fabien COELHO , "pgsql-hackers@lists.postgresql.org" Subject: Re: psql - add SHOW_ALL_RESULTS option - pg_regress output Message-ID: <20220406020621.dfwvyuagy6tlc3fo@alap3.anarazel.de> References: <63350f81-6a43-f536-24e6-b30f48797732@enterprisedb.com> <9621d9b8-6e27-ba1a-069e-c44a0dd3a7ba@enterprisedb.com> <8441a96a-5db0-6f41-1d23-7018811e2c87@enterprisedb.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <8441a96a-5db0-6f41-1d23-7018811e2c87@enterprisedb.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, On 2022-04-04 23:32:50 +0200, Peter Eisentraut wrote: > This has been committed. It's somewhat annoying that made pg_regress even more verbose than before: ============== removing existing temp instance ============== ============== creating temporary instance ============== ============== initializing database system ============== ============== starting postmaster ============== running on port 51696 with PID 2203449 ============== creating database "regression" ============== CREATE DATABASE ALTER DATABASE ALTER DATABASE ALTER DATABASE ALTER DATABASE ALTER DATABASE ALTER DATABASE ============== running regression test queries ============== Unfortunately it appears that neither can CREATE DATABASE set GUCs, nor can ALTER DATABASE set multiple GUCs in one statement. Perhaps we can just set SHOW_ALL_RESULTS off for that psql command? - Andres