Postgres Pro
Downloads
Home   >   mailing lists

Re: Transaction and SQL errors - Mailing list pgsql-general

From Sebastien Flaesch
Subject Re: Transaction and SQL errors
Date
Msg-id DBAP191MB1289EB1811010BAF470B6228B0E59@DBAP191MB1289.EURP191.PROD.OUTLOOK.COM
Whole thread Raw
In response to Re: Transaction and SQL errors  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
List pgsql-general
Tree view
Hi Karsten,

No...  see the doc: https://www.postgresql.org/docs/14/app-psql.html

ON_ERROR_ROLLBACK

When set to on, if a statement in a transaction block generates an error, the error is ignored and the transaction continues.

Seb

pgsql-general by date:

Previous
From: "J. Roeleveld"
Date:
Subject: Select .... where id not in (....) returns 0 incorrectly
Next
From: Sebastien Flaesch
Date:
Subject: Re: Transaction and SQL errors