Martin Pitt <[EMAIL PROTECTED]> writes:
> What do you think about displaying a different prompt when a
> transaction is pending,
That's been possible for a long time, see the prompt-string variable
in psql.
regards, tom lane
---(end of broadcast)--
Martin Pitt said:
> If you just output a rollback command on exit, then it is already too
> late to rescue the pending transaction, so I'm not sure whether that
> would help this use case so much.
Well, the DBA can always replay the transaction manually -- I think
notifying the DBA that their modi
Hi,
Neil Conway [2007-09-17 10:16 -0700]:
> At a minimum, I think we could make the fact that the transaction
> has been rolled back more obvious (e.g. echo a ROLLBACK command tag
> to the output or a similar warning message). Asking for confirmation
> might be too chatty, and it's certainly not p
Neil Conway <[EMAIL PROTECTED]> writes:
> At a minimum, I think we could make the fact that the transaction
> has been rolled back more obvious (e.g. echo a ROLLBACK command tag
> to the output or a similar warning message). Asking for confirmation
> might be too chatty, and it's certainly not poss
On Sun, 2007-09-16 at 20:34 +0200, Martin Pitt wrote:
> users=> begin;
> BEGIN
> [...]
> users=> \q
> $ ...
>
> It would be really nice if psql prompted me whether I wanted to do
> this. As it stands, it just rolls back the transaction."
At a minimum, I think we could make the fact that the trans