Re: POLL: Adding transaction status to default psql prompt

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Vik Fearing <vik(at)postgresfriends(dot)org>
Cc: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: POLL: Adding transaction status to default psql prompt
Date: 2020-02-06 07:20:03
Message-ID: CAECtzeVC=J3FTjx_gmem3_8U2j5EDFWTVj+dPonQvx-xHtxDSA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Le jeu. 6 févr. 2020 à 03:55, Vik Fearing <vik(at)postgresfriends(dot)org> a
écrit :

> 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,
>

Too bad it doesn't add a space, so that we still have the same space used
byt the prompt whatever the status of the transaction. That's probably the
only thing that bugs me with %x.

- 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.
>

+1 from me as well. Actually, thanks to you, I added it to my .psqlrc file
in the meantime. But it would be very interesting when I work on a
customer's server.

--
Guillaume.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Vikram Sah 2020-02-06 09:36:38 Function not imported in Entity Framework
Previous Message Laurenz Albe 2020-02-06 06:11:33 Re: POLL: Adding transaction status to default psql prompt