Re: Transaction and SQL errors

From: Sebastien Flaesch <sebastien(dot)flaesch(at)4js(dot)com>
To: Karsten Hilbert <karsten(dot)hilbert(at)gmx(dot)net>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Transaction and SQL errors
Date: 2022-04-04 12:38:47
Message-ID: DBAP191MB1289EB1811010BAF470B6228B0E59@DBAP191MB1289.EURP191.PROD.OUTLOOK.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sebastien Flaesch 2022-04-04 12:41:36 Re: Transaction and SQL errors
Previous Message J. Roeleveld 2022-04-04 12:08:27 Select .... where id not in (....) returns 0 incorrectly