psql CLI: warn about ongoing transaction on exit

Hello PostgreSQL developers,

we recently got a wishlist Debian bug [1] that asks for the psql
command line tool to "warn about an ongoing transaction on exit:

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."

Does this stand a chance to get implemented/accepted? I'm happy to
look into this and craft a patch if you would adopt it upstream.

Thanks,

Martin

[1] http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=439943

--
Martin Pitt        http://www.piware.de
Ubuntu Developer   http://www.ubuntu.com
Debian Developer   http://www.debian.org