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.96) (envelope-from ) id 1vlFxU-009Kea-1H for pgsql-hackers@arkaria.postgresql.org; Thu, 29 Jan 2026 00:32:28 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vlFxT-004rwt-10 for pgsql-hackers@arkaria.postgresql.org; Thu, 29 Jan 2026 00:32:27 +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.96) (envelope-from ) id 1vlFxS-004rwP-3C for pgsql-hackers@lists.postgresql.org; Thu, 29 Jan 2026 00:32:27 +0000 Received: from fout-a1-smtp.messagingengine.com ([103.168.172.144]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vlFxN-002pSm-1z for pgsql-hackers@lists.postgresql.org; Thu, 29 Jan 2026 00:32:26 +0000 Received: from phl-compute-03.internal (phl-compute-03.internal [10.202.2.43]) by mailfout.phl.internal (Postfix) with ESMTP id 24FFDEC030E; Wed, 28 Jan 2026 19:32:21 -0500 (EST) Received: from phl-frontend-03 ([10.202.2.162]) by phl-compute-03.internal (MEProxy); Wed, 28 Jan 2026 19:32:21 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:subject :subject:to:to; s=fm3; t=1769646741; x=1769733141; bh=s7LsvMdLzn e6VYY5XMiLrAfj1WtD8z/A+BIZQ1WQVaM=; b=Y2/HlUm8Tye38Mdh9vmtdDp3hN K6IfDx8lhU37lpYJAQJkxZCaRwhVzPe+BZ4O1fm7uJaGYLFb2gAc9M0EVl9Ahr2i F9zO9UI0LC2JBVfGPDf8qzCKra+N8oQB/x/lBYj/FNfoIJMRT2guwVuetKbx7rbR OsIVryJqu3XK+ffKvHy9xeADSa6XXarzzUkxsgier/nJTSTS/t3DAb7o2QzAYddF nRGdX1od/hmP2YEvtXasATO7hkwXNOSNSwTw9IHU9V6CimQgv0Z65lYDmWOj+xku oSl+nIw4cHQ8j5QEwynRCZuA5aMoXkzZaHH7tu1AX0Fyg1wt/DYZjHsHL5AQ== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:subject:subject:to :to:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm3; t= 1769646741; x=1769733141; bh=s7LsvMdLzne6VYY5XMiLrAfj1WtD8z/A+BI ZQ1WQVaM=; b=v1h0o8eqvVvyTZn+Wk2aMkRGFd0+rTD693OtccMTngrVvlwBRRL TNpxYQlYwwzzWVsIgKEHyxfXgFHtAQlgkx9YwLc3VHYb7l2Qtu+Y5f8REQyS4mgo ivyywVBLD5TXn/uhSpbTRgeRk4vOc73BZBFvbvfozzAMvy6QucyCDU1I0GS8A5XW +a8kNF4wgGc9vgFofUEZSbCkCBFivymBG1dspO1lbdbQsAOfQ1/Z/bupPGwbdYkI DuaM1FjsxZ7M5/xu28ufsbW4cDXUj+uZfC/oscf6c/F1YFky4glE2uIonu4F+Icm iqVpM+hR5fZeFBbVwUUwkmE+4UYOgjZkftg== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefgedrtddtgdduieegjeeiucetufdoteggodetrf dotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfurfetoffkrfgpnffqhgenuceu rghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmnegfrh hlucfvnfffucdljedtmdenucfjughrpeffhffvvefukfhfgggtuggjsehgtderredttdej necuhfhrohhmpefoihgthhgrvghlucfrrghquhhivghruceomhhitghhrggvlhesphgrqh huihgvrhdrgiihiieqnecuggftrfgrthhtvghrnhepveetjefgjeevgedukeehieeuieeu ieevueeiudegheevuefggfduueelgeelieetnecuvehluhhsthgvrhfuihiivgeptdenuc frrghrrghmpehmrghilhhfrhhomhepmhhitghhrggvlhesphgrqhhuihgvrhdrgiihiidp nhgspghrtghpthhtohepvddpmhhouggvpehsmhhtphhouhhtpdhrtghpthhtoheplhhird gvvhgrnhdrtghhrghosehgmhgrihhlrdgtohhmpdhrtghpthhtohepphhgshhqlhdqhhgr tghkvghrsheslhhishhtshdrphhoshhtghhrvghsqhhlrdhorhhg X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 28 Jan 2026 19:32:18 -0500 (EST) Date: Thu, 29 Jan 2026 09:32:14 +0900 From: Michael Paquier To: Chao Li Cc: PostgreSQL Hackers Subject: Re: psql: make %P prompt option consistent when not connected Message-ID: References: <86EF76B5-6E62-404D-B9EC-66F4714D7D5F@gmail.com> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="8Q3flnjdFI7caQqu" Content-Disposition: inline In-Reply-To: <86EF76B5-6E62-404D-B9EC-66F4714D7D5F@gmail.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --8Q3flnjdFI7caQqu Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Wed, Jan 28, 2026 at 04:38:08PM +0800, Chao Li wrote: > While reviewing and testing patch [1], I noticed that psql=E2=80=99s %P > prompt option does not check pset.db, which makes it inconsistent > with other prompt options. As a result, when there is no database > connection, other prompt elements are suppressed, but the pipeline > status is still shown. Point taken. It's true that it is confusing to show an "off" status in this case if we don't have an active connection. Will adjust and backpatch. -- Michael --8Q3flnjdFI7caQqu Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAml6qo4ACgkQnvQgOdby QH0VdRAAlyyB1ug6o7Y8q8bd34X7yC3YA9AKOJYcxt+du9mtbyQzh6/yYuZwJ1GB iMg/ZDvSy/FThUTxVviX9ThY+x8aSFpqbk+Wk7E8/0umuANxitzLLRof3+Sn7NDn 7pS2okmrAqs+cNWoYHcRwaiPU1XoX++2B8n1PzdLEpGah34YUxNB3S1OKnvrjN8v npbnnM++VU1XueU7wLAzVSBjGLNRa5Mroq5rLVKv/kf3fWOdX+9FEDmgT39Vl8mH EEvlY7E3A5XXi7P/OB/J2a3Csb2D/Un+NaQBOBSdL1Fne3A0nLtajuil8BVSHFkm riZocOQ8vvcU4StEYCAFr1oe+EfYo4nl3DxdttqkVAz8iqYHAddmxp8tYE6vh4Fc /PqMGFL6eLQ/ElKuOKTykrk9yLSkDbzup0Cwi1VyAcER9WlqWdFihiA7G5SV/l1U NAkjVH7S1nVD2566ZQJKWAvhtzUpYODD+j5o8WGlIaJdtro69c+YHdRtkefyyw3Q qVpeol05Dq7mRjrjH7pdq9oq88HgSa5Tw2isb3tV8Rzeq4biYBjUNwDDZGO07bOs mCrBltvsJf82FL38M/+eF8UAP/w685B6Dr+6EAaHaJVhipP5IcjjQ56CjQozmLGT 3eumwJMBcqKwbgQouch7do+PKphfKlFhs+DZfpmoh1RLcTQVNNE= =fChx -----END PGP SIGNATURE----- --8Q3flnjdFI7caQqu--