Re: Transaction status in default psql prompt?

Tom Lane wrote:
> Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> > What do people think about adding the transaction status indicator to the
> > default psql prompt, so it'd look something like this:
>
> Okay with me.
>
> > Btw., would anyone mind if the code for this indicator where not %T, but
> > say instead %x, because there is a correspondence between psql's codes and
> > tcsh's, and tcsh uses %T for the hour of the day, which is something that
> > someone might want to add someday.
>
> Go for it. I chose %T at random, if there's a potential conflict now is
> the time to fix it.

If we vote to do it, can we have a place holder for when we are _not_ in
a transaction, so the prompt doesn't move around:

test==> BEGIN;
test=*> SELECT 1;

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073