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