On Wed, 3 Sep 2003 [EMAIL PROTECTED] wrote:
Date: Wed, 3 Sep 2003 19:32:52 -0400 (EDT)
From: Bruce Momjian <[EMAIL PROTECTED]>
To: Peter Eisentraut <[EMAIL PROTECTED]>
Cc: PostgreSQL Development <[EMAIL PROTECTED]>
Subject: Re: Transaction status in default psql prompt?
Message-ID: <[EMAIL PROTECTED]>
Peter Eisentraut wrote:
> > What do people think about adding the transaction status indicator to
> > the default psql prompt, so it'd look something like this:
> >
> > peter=# begin;
> > BEGIN
> > peter*=# foo;
> > ERROR: syntax error at or near "foo" at character 1
> > peter!=# rollback;
> > ROLLBACK
> > peter=#
> >
> > I think many people would find that useful.
> >
> > 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.
> If you take a close look at the output above, you will see that the
> prompt shifts one character to the right when you are in a transaction.
> That is going to look terrible. I don't think we should have a moving
> prompt as a default.
On the contrary, it could show the transaction level for the case of
nested transactions:
foo**=#
could mean you are within the 2nd nested transaction block, which I'd find
convenient.
--
Serguei A. Mokhov | /~\ The ASCII
Computer Science Department | \ / Ribbon Campaign
Concordia University | X Against HTML
Montreal, Quebec, Canada | / \ Email!
"I swear, education is the only industry, where
the consumer is happier when they get less
for their money" -- Julia Timofeev
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
