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 <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1izNag-0006rs-Oc
	for pgsql-hackers@arkaria.postgresql.org; Wed, 05 Feb 2020 16:31:50 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1izNae-0007VK-F4
	for pgsql-hackers@arkaria.postgresql.org; Wed, 05 Feb 2020 16:31:48 +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 <coelho@cri.ensmp.fr>)
	id 1izNae-0007Ro-2q
	for pgsql-hackers@lists.postgresql.org; Wed, 05 Feb 2020 16:31:48 +0000
Received: from courriel.mines-paristech.fr ([77.158.173.149]
 helo=antispam-1.ensmp.fr)
	by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <coelho@cri.ensmp.fr>)
	id 1izNaa-0000WV-VE
	for pgsql-hackers@postgresql.org; Wed, 05 Feb 2020 16:31:46 +0000
Received: from smtp-5.mines-paristech.fr (smtp.mines-paristech.fr
 [77.158.173.146])
	(using TLSv1.2 with cipher AECDH-AES256-SHA (256/256 bits))
	(No client certificate requested)
	by antispam-1.ensmp.fr (antispam.mines-paristech.fr) with ESMTPS id
 AE2A455EEA;
	Wed,  5 Feb 2020 17:31:41 +0100 (CET)
Received: from pseudo (195.237.219.88.rev.sfr.net [88.219.237.195])
	(using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits))
	(No client certificate requested)
	by smtp-5.mines-paristech.fr (Postfix) with ESMTPSA id E979520077;
	Wed,  5 Feb 2020 17:31:40 +0100 (CET)
Date: Wed, 5 Feb 2020 17:31:38 +0100 (CET)
From: Fabien COELHO <coelho@cri.ensmp.fr>
X-X-Sender: fabien@pseudo
To: Michael Paquier <michael@paquier.xyz>
cc: Ian Barwick <ian.barwick@2ndquadrant.com>, Tom Lane <tgl@sss.pgh.pa.us>,
    Daniel Gustafsson <daniel@yesql.se>,
    Vik Fearing <vik.fearing@2ndquadrant.com>,
    PostgreSQL-development <pgsql-hackers@postgresql.org>
Subject: Re: Add %x to PROMPT1 and PROMPT2
In-Reply-To: <20200204082036.GA94169@paquier.xyz>
Message-ID: <alpine.DEB.2.21.2002051726400.21385@pseudo>
References: <09502c40-cfe1-bb29-10f9-4b3fa7b2bbb2@2ndquadrant.com>
 <alpine.DEB.2.21.2001261946530.29788@pseudo>
 <e04078e8-ae4a-b09d-896d-5f2f5a042248@2ndquadrant.com>
 <alpine.DEB.2.21.2001271250190.24374@pseudo>
 <13bc9081-2cf8-bf99-bedb-ce70c82bebc8@2ndquadrant.com>
 <20200203070807.GD2180@paquier.xyz>
 <5E008326-2335-4FB2-8513-D9018EC94F02@yesql.se>
 <6749.1580740801@sss.pgh.pa.us>
 <79ac1ca0-2bab-bbe4-126a-01966f812075@2ndquadrant.com>
 <20200204082036.GA94169@paquier.xyz>
User-Agent: Alpine 2.21 (DEB 202 2017-01-01)
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII; format=flowed
X-CLAMAV-SCAN: ok
X-VRSPAM-SCORE: -100
X-VRSPAM-STATE: legit
X-VRSPAM-CAUSE: 
 gggruggvucftvghtrhhoucdtuddrgedugedrhedugdekkecutefuodetggdotefrucfrrhhofhhilhgvmecuggftfghnshhusghstghrihgsvgenuceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmnecujfgurhepfffhvffujgfkfhgfgggtsehttdertddtredvnecuhfhrohhmpefhrggsihgvnhcuvefqgffnjffquceotghovghlhhhosegtrhhirdgvnhhsmhhprdhfrheqnecukfhppeekkedrvdduledrvdefjedrudelheenucfrrghrrghmpehmohguvgepshhmthhpohhuth
X-VRSPAM-EXTCAUSE: mhhouggvpehsmhhtphhouhht
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>
Precedence: bulk


>> +1 one for this change, it's something I also add to every .psqlrc I setup.
>
> So..  We have:
> +1: Vik, Ian, Daniel, Alvaro, Christoph
> +-0: Tom (?), Fabien (?)

I did not know I had a vote. I'm "+1" on this change, if that matters.

Just this morning I had a case where I wished I had the current 
transaction status under the eye under psql.

> -1: Michael P.
>
> So there is a clear majority in favor of changing the default.  Any
> extra opinions from others?

-- 
Fabien.