On Thu, 2020-07-02 at 09:31 -0700, Adrian Klaver wrote: > I would say just add a message to the ERROR that points out > ON_ERROR_ROLLBACK = 'on' is available. For instance: > > test(5432)=# begin ; > BEGIN > test(5432)=# select 1/0; > ERROR: division by zero > test(5432)=# select 1; > ERROR: current transaction is aborted, commands ignored until end of > transaction block > > New part of message > HINT: \set ON_ERROR_ROLLBACK on to rollback on error. -1 That would increase the already annoying spam of "current transaction is aborted" messages when your transaction fails. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com
