Skip site navigation (1) Skip section navigation (2)

Re: psql CLI: warn about ongoing transaction on exit

From: Neil Conway <neilc(at)samurai(dot)com>
To: Martin Pitt <martin(at)piware(dot)de>
Cc: PostgreSQL Bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: psql CLI: warn about ongoing transaction on exit
Date: 2007-09-17 17:16:12
Message-ID: 1190049372.26891.10.camel@dell.linuxdev.us.dell.com (view raw or flat)
Thread:
Lists: pgsql-bugs
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 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 possible in
non-interactive mode.

-Neil



In response to

Responses

pgsql-bugs by date

Next:From: hubert depesz lubaczewskiDate: 2007-09-17 18:37:45
Subject: autovacuum starting for no apparent reason
Previous:From: Michael AkindeDate: 2007-09-17 13:36:54
Subject: BUG #3614: pg_config returns incorrect information for includedir-server

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group