Обсуждение: POLL: Adding transaction status to default psql prompt

Hello,

I proposed a patch to add %x to PROMPT1 and PROMPT2 by default in psql.

The effect of this is:

- nothing at all when not in a transaction,
- adding a '*' when in a transaction or a '!' when in an aborted
  transaction.

Before making a change to a long-time default, a poll in this group was
requested.

Please answer +1 if you want or don't mind seeing transaction status by
default in psql or -1 if you would prefer to keep the current default.

Thanks!

+1 from me.
-- 
Vik Fearing

+1

-----Original Message-----
From: Vik Fearing <vik@postgresfriends.org>
Sent: Thursday, 6 February 2020 1:55 PM
To: pgsql-general@lists.postgresql.org
Subject: POLL: Adding transaction status to default psql prompt

Hello,

I proposed a patch to add %x to PROMPT1 and PROMPT2 by default in psql.

The effect of this is:

- nothing at all when not in a transaction,
- adding a '*' when in a transaction or a '!' when in an aborted
  transaction.

Before making a change to a long-time default, a poll in this group was requested.

Please answer +1 if you want or don't mind seeing transaction status by default in psql or -1 if you would prefer to
keepthe current default.
 

Thanks!

+1 from me.
--
Vik Fearing



IMPORTANT NOTE: Fuji Xerox email transmission, including any attachments, is private and confidential and may contain
legallyprivileged information. It is for the addressee's attention only. If you are not the intended recipient and have
receivedthis transmission, you must not use, edit, print, copy or disclose its contents to any person or disseminate
theinformation contained herein or hereto attached, and you must notify sender immediately by return email and delete
thistransmission from your system. Any confidentiality, privilege or copyright is not waived or lost because this
e-mailhas been sent to you in error. We have used reasonable efforts to protect this transmission from computer viruses
andother malicious software, but no warranty is made and the sender takes no responsibility for any loss or damage
incurredfrom using this email or the information contained in this email.
 

+1

On Wed, Feb 5, 2020 at 9:15 PM Ahmed, Nawaz (Fuji Xerox Australia)
<Nawaz.Ahmed@aus.fujixerox.com> wrote:
>
> +1
>
> -----Original Message-----
> From: Vik Fearing <vik@postgresfriends.org>
> Sent: Thursday, 6 February 2020 1:55 PM
> To: pgsql-general@lists.postgresql.org
> Subject: POLL: Adding transaction status to default psql prompt
>
> Hello,
>
> I proposed a patch to add %x to PROMPT1 and PROMPT2 by default in psql.
>
> The effect of this is:
>
> - nothing at all when not in a transaction,
> - adding a '*' when in a transaction or a '!' when in an aborted
>   transaction.
>
> Before making a change to a long-time default, a poll in this group was requested.
>
> Please answer +1 if you want or don't mind seeing transaction status by default in psql or -1 if you would prefer to
keepthe current default. 
>
> Thanks!
>
> +1 from me.
> --
> Vik Fearing
>
>
>
> IMPORTANT NOTE: Fuji Xerox email transmission, including any attachments, is private and confidential and may contain
legallyprivileged information. It is for the addressee's attention only. If you are not the intended recipient and have
receivedthis transmission, you must not use, edit, print, copy or disclose its contents to any person or disseminate
theinformation contained herein or hereto attached, and you must notify sender immediately by return email and delete
thistransmission from your system. Any confidentiality, privilege or copyright is not waived or lost because this
e-mailhas been sent to you in error. We have used reasonable efforts to protect this transmission from computer viruses
andother malicious software, but no warranty is made and the sender takes no responsibility for any loss or damage
incurredfrom using this email or the information contained in this email. 

On 06/02/2020 04:55, Steve Baldwin wrote:
> Hi Vik,
> 
> I'm not sure why this should be the default when it is easy to override the
> default via a psqrc file. If you know enough to do it, you can.

Because it isn't always easy to modify the .psqlrc file.  This is
especially true if you frequently connect to other people's systems.

> Otherwise I
> don't think it adds any value as a default since a novice user isn't going
> to know what */!/? means. Maybe I'm missing something.

A novice user won't understand any of psql's meta commands, either.

> -1 from me.

Thank you for voting.
-- 
Vik Fearing

On 06/02/20 8:24 am, Vik Fearing wrote:
> Hello,
>
> I proposed a patch to add %x to PROMPT1 and PROMPT2 by default in psql.
>
> The effect of this is:
>
> - nothing at all when not in a transaction,
> - adding a '*' when in a transaction or a '!' when in an aborted
>    transaction.
>
> Before making a change to a long-time default, a poll in this group was
> requested.
>
> Please answer +1 if you want or don't mind seeing transaction status by
> default in psql or -1 if you would prefer to keep the current default.
>
> Thanks!
>
> +1 from me.
double +1 from me

On Thu, Feb 06, 2020 at 03:54:48AM +0100, Vik Fearing wrote:
> I proposed a patch to add %x to PROMPT1 and PROMPT2 by default in psql.
>
> The effect of this is:
>
> - nothing at all when not in a transaction,
> - adding a '*' when in a transaction or a '!' when in an aborted
>   transaction.
>
> Before making a change to a long-time default, a poll in this group was
> requested.

Thanks Vik for starting a new thread.  For reference here is the
thread where the patch is being discussed:
https://www.postgresql.org/message-id/09502c40-cfe1-bb29-10f9-4b3fa7b2bbb2@2ndquadrant.com
--
Michael

> On Feb 5, 2020, at 18:54, Vik Fearing <vik@postgresfriends.org> wrote:
> Please answer +1 if you want or don't mind seeing transaction status by
> default in psql or -1 if you would prefer to keep the current default.

+1.

On 2/5/20 8:05 PM, Vik Fearing wrote:
> On 06/02/2020 04:55, Steve Baldwin wrote:
>> Hi Vik,
>>
>> I'm not sure why this should be the default when it is easy to override the
>> default via a psqrc file. If you know enough to do it, you can.
> 
> Because it isn't always easy to modify the .psqlrc file.  This is
> especially true if you frequently connect to other people's systems.
> 
>> Otherwise I
>> don't think it adds any value as a default since a novice user isn't going
>> to know what */!/? means. Maybe I'm missing something.
> 
> A novice user won't understand any of psql's meta commands, either.

Except they can be found by doing \?

-1

> 
>> -1 from me.
> 
> Thank you for voting.
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com

On Thu, 2020-02-06 at 03:54 +0100, Vik Fearing wrote:
> I proposed a patch to add %x to PROMPT1 and PROMPT2 by default in psql.

+1

Yours,
Laurenz Albe

On Thu, Feb 06, 2020 at 03:54:48AM +0100, Vik Fearing wrote:
> Please answer +1 if you want or don't mind seeing transaction status by
> default in psql or -1 if you would prefer to keep the current default.

+1

depesz

On 06/02/2020 02:54, Vik Fearing wrote:
> Hello,
> 
> I proposed a patch to add %x to PROMPT1 and PROMPT2 by default in psql.
> 
> The effect of this is:
> 
> - nothing at all when not in a transaction,
> - adding a '*' when in a transaction or a '!' when in an aborted
>   transaction.
> 
> Before making a change to a long-time default, a poll in this group was
> requested.
> 
> Please answer +1 if you want or don't mind seeing transaction status by
> default in psql or -1 if you would prefer to keep the current default.

+1


-- 
Raymond O'Donnell // Galway // Ireland
ray@rodonnell.ie

> Please answer +1 if you want or don't mind seeing transaction status by
> default in psql or -1 if you would prefer to keep the current default.

+1

-- 
Charles Clavadetscher
Swiss PostgreSQL Users Group
Treasurer
Spitzackerstrasse 9
CH - 8057 Zürich

http://www.swisspug.org

+---------------------------+
|     ____  ______  ___     |
|    /    )/      \/   \    |
|   (     / __    _\    )   |
|    \    (/ o)  ( o)   )   |
|     \_  (_  )   \ ) _/    |
|       \  /\_/    \)/      |
|        \/ <//|  |\\>      |
|             _|  |         |
|             \|_/          |
|                           |
|     Swiss PGDay 2020      |
|      18/19.06.2020        |
|      HSR Rapperswil       |
|                           |
+---------------------------+