Re: [BUGS] psql CLI: warn about ongoing transaction on exit

2007-09-18 Thread Tom Lane
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)--

Re: [BUGS] psql CLI: warn about ongoing transaction on exit

2007-09-17 Thread Neil Conway
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

Re: [BUGS] psql CLI: warn about ongoing transaction on exit

2007-09-17 Thread Martin Pitt
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

Re: [BUGS] psql CLI: warn about ongoing transaction on exit

2007-09-17 Thread Tom Lane
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

Re: [BUGS] psql CLI: warn about ongoing transaction on exit

2007-09-17 Thread Neil Conway
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