On Wed, 2012-06-20 at 00:24 -0700, Chris Travers wrote:
> I guess it seems to me that I would not object to a new option for
> transaction behavior where one could do something like SET TRANSACTION
> INTERACTIVE; and have no errors abort the transaction at all (explicit
> commit or rollback required) but I would complain loudly if this were
> to be the default, and I don't see a real need for it.
It's already available in psql. See ON_ERROR_ROLLBACK:
http://www.postgresql.org/docs/9.2/static/app-psql.html
Regards,
Jeff Davis