Re: survey: psql syntax errors abort my transactions - Mailing list pgsql-general

From Laurenz Albe
Subject Re: survey: psql syntax errors abort my transactions
Date
Msg-id 0f707f39184a972e8404061fac6bbce1635e7f93.camel@cybertec.at
Whole thread Raw
In response to Re: survey: psql syntax errors abort my transactions  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
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




pgsql-general by date:

Previous
From: Adam Brusselback
Date:
Subject: Re: Does TOAST really compress the complete row?
Next
From: Laurenz Albe
Date:
Subject: Re: survey: psql syntax errors abort my transactions