Re: [PATCHES] Automatic transactions in psql

...
> > 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. It does this
> > by issuing a BEGIN at the appropriate times. This patch
> > (if ever accepted) conflicts a bit with LO_RTANSACTION:
> > psql now *does* have a way to know if it is in a
> > transaction or not, so that part may need to get rewritten.

This part of the feature (corresponding to the Ingres "autocommit = off"
feature) should be implemented in the backend rather than in psql. I've
had a moderate interest in doing this but haven't gotten to it; if
someone wants to pick it up I'm sure it would be well received...
                     - Thomas