From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
---|---|
To: | Greg Sabino Mullane <greg(at)turnstep(dot)com> |
Cc: | <pgsql-patches(at)postgresql(dot)org> |
Subject: | Re: Automatic transactions in psql |
Date: | 2002-02-07 00:17:25 |
Message-ID: | Pine.LNX.4.30.0202061913070.682-100000@peter.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
Greg Sabino Mullane writes:
> The attached patch actually does two related things. First,
> it keeps track of whether or not you are in a trnasaction
> and modifies the prompt slightly when you are by putting
> an asterick at the very front of it.
This is an interesting idea, although you may want to give the user the
option to customize his prompt. Add an escape, maybe %* or %t, with the
meaning "resolves to * if in a transaction block and to the empty string
if not". (The existing escapes were all stolen from tcsh, so look there
if you need an idea.)
> Secondly, it adds a "begin transaction" option that, when
> enabled, ensures that you are always inside a transaction
> while in psql, so you can always rollback.
This should be done in the backend.
--
Peter Eisentraut peter_e(at)gmx(dot)net
From | Date | Subject | |
---|---|---|---|
Next Message | Brian Bruns | 2002-02-07 00:27:20 | function and variable names |
Previous Message | Peter Eisentraut | 2002-02-07 00:10:54 | Re: Explicit configuration patch. |
From | Date | Subject | |
---|---|---|---|
Next Message | Christopher Kings-Lynne | 2002-02-07 00:51:14 | Re: Automatic transactions in psql |
Previous Message | Justin Clift | 2002-02-07 00:06:10 | Re: contrib/pg_filedump - PostgreSQL File Dump Utility |